VLookup and Sort difficulties

K

kleivakat

I have a column in a worksheet that uses vlookup function. The formula in my
first line is:

=VLOOKUP(I2,PRODUCTLINE!$A$1:$C$540,3,FALSE)
....where I2 is the first cell that it references to match a value.

The next one logically is:
=VLOOKUP(I3,PRODUCTLINE!$A$1:$C$540,3,FALSE)
....where I3 is the cell that the next line references.

So now I have my spreadsheet with all the PRODUCTLINE cells filled in
correctly and I'd like to sort by Product Line. But when I do a datasort, it
takes me back to the original order because it's sorting on the formula
above, not the resulting Product Line verbiage.

Thoughts? Suggestions?

KK
 
E

excelent

try copy ur vlookup-values to another column pasted as value
then u can sort on that new column

"kleivakat" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Need Help with VLOOKUP 4
Macro 3
VLOOKUP & Data Validation 0
excel formula is returning incorrect values 0
Same forumula returns both 0 & N/A 2
Easiest way to find differences between Rows? 3
VLookup 6

Top