Vlookup

[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

 

[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

 

[Jamie]

Thanks!

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