V Look Up Function Problems

T

tweacle

I have a V look up table set up and has a list of stations and cos
centre no's
See below:-
Brondesbury Park 4-2-08-00
Brondesbury 4-2-09-00
West Hampstead 4-2-10-00
Finchley Road & Frognal 4-2-11-00
Hampstead Heath 4-2-12-00
Gospel Oak 4-2-13-00
Kensington Olympia 4-2-25-00

I seem to get some stations ok and others dont come up. I.E I put i
Brondesbury as the station and the offcost code comes up ok. If I wa
to put in Gospel Oak for instance it comes up with the value of "0" o
#n/a. Why is this happening. I have the argument no 4 set to "false
cos I need to have a exact match.

Can anyone help
 
L

L. Howard Kittle

Make sure the 2 Gospel Oak's are indeed identical. Perhaps you have a space
after one or the other. =A1=B1 as a test. Change A1/B1 to the Gospel Oak
cells. True = same, false = not same.

HTH
Regards,
Howard
 
K

Ken Wright

If it comes up with #N/A then what you have entered does not match what is
in the list. Check for rogue spaces.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top