VLookUp problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you are creating a vlookup, does the lookup table HAVE to be sorted
alphabetically to work, or the lookup table and the original worksheet?

I've been working on a lookup for a while and always get N/A so i know i'm
going wrong somewhere.........

Anybody help???

Thank you
Louise
 
The lookup table has to be sorted if you set the fourth parameter of VLOOKUP
to TRUE. Setting it to FALSE won't require the table to be sorted.
The original worksheet can be at any order.

Hope this helps,
Miguel.
 
Back
Top