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

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

"kleivakat" skrev:

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