Hi all... I'm sure tihs is a simple VLOOKUP problem, but I can't seem to
figure out the issue.
I have a lookup table of Nation abbreviations and the corresponding full
name:
IN India
IO British Indian Ocean Terr
IP Clipperton Island
IR Iran
IS Israel
IT Italy
IV Cote D'Ivoire
IZ Iraq
On a separate page, I have a listing of nations for people in a program (by
CODE). I want to use VLOOKUP to take the coded country and return the
nation name.
So,
A B C
IT [formula] Italy
I entered the following formula:
=VLOOKUP(A1,NationLookup,2)
The formula 'works', but not properly. Using the example above, it would
return ISRAEL instead of ITALY. It seems to be finding the right code, but
returning the value from one row up in the lookup table.
Anyone know how to fix this??
B
Bookmarks