VLookup and Sort difficulties

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
>
>