I have a V look up table set up and has a list of stations and cost
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 in
Brondesbury as the station and the offcost code comes up ok. If I was
to put in Gospel Oak for instance it comes up with the value of "0" or
#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?


--
tweacle

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

"tweacle" wrote in message
...

I have a V look up table set up and has a list of stations and cost
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 in
Brondesbury as the station and the offcost code comes up ok. If I was
to put in Gospel Oak for instance it comes up with the value of "0" or
#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?


--
tweacle

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 :-)
------------------------------*------------------------------*----------------



"tweacle" wrote in message
...

I have a V look up table set up and has a list of stations and cost
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 in
Brondesbury as the station and the offcost code comes up ok. If I was
to put in Gospel Oak for instance it comes up with the value of "0" or
#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?


--
tweacle