Vlookup

J

Jamie

Hi to all
I am using a vlookup in my workbook that uses lookup range from another
workbook. Although i can add data (helper columns etc.) to this other
workbook, I cannot sort the lookup range in the other workbook. How can I
copy this data into my workbook and sort it so I may use vlookup.
Thanks
Jamie
 
L

LanceB

If the issues is only that the lookup range is not sorted you can use the
vlookup syntax vlookup(YourLookup,YourRange,column,FALSE)

The false will look for an exact match and does not require a sorted range.

Lance
 
J

Jamie

Thanks!
LanceB said:
If the issues is only that the lookup range is not sorted you can use the
vlookup syntax vlookup(YourLookup,YourRange,column,FALSE)

The false will look for an exact match and does not require a sorted range.

Lance
Click to expand...
 
Top