vlookup formula not working.....

  • Thread starter Thread starter flick
  • Start date Start date
F

flick

i have a table that looks like this
Brendan Analyst #N/A 15
Paul Clerk 13 45 585
Con Programmer 42 47 1974
Angela Manager 51 38 1938
Julie Manager 51 38 1938

further up ranging from G3:H7 i have a table which i've named position
table that looks somewhat like this:
Position Rate
Analyst $35.00
Clerk $13.00
Manager $51.00
Programmer $42.00

as u can see from the above employee list table i'm having trouble
with this n/a thingy..... only in tha first row.... i've used the
vlookup formula for the rest of the table and it works perfectly fine
where am i going wrong..... all help is greatly appreciated
 
If I'm not mistaken, your first column doesn't appear to be sorted
alphabetically. In order for a v-lookup to work successfully, the
first column must be sorted alphabetically in ascending order.
Otherwise you'll get inconsistent results.

Hope this helps.
 
Back
Top