software

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 amp; 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 quot;0quot; or
#n/a. Why is this happening. I have the argument no 4 set to quot;falsequot;
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

quot;tweaclequot; gt; wrote in message
...
gt;
gt; I have a V look up table set up and has a list of stations and cost
gt; centre no's
gt; See below:-
gt; Brondesbury Park 4-2-08-00
gt; Brondesbury 4-2-09-00
gt; West Hampstead 4-2-10-00
gt; Finchley Road amp; Frognal 4-2-11-00
gt; Hampstead Heath 4-2-12-00
gt; Gospel Oak 4-2-13-00
gt; Kensington Olympia 4-2-25-00
gt;
gt; I seem to get some stations ok and others dont come up. I.E I put in
gt; Brondesbury as the station and the offcost code comes up ok. If I was
gt; to put in Gospel Oak for instance it comes up with the value of quot;0quot; or
gt; #n/a. Why is this happening. I have the argument no 4 set to quot;falsequot;
gt; cos I need to have a exact match.
gt;
gt; Can anyone help?
gt;
gt;
gt; --
gt; 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 :-)
------------------------------*------------------------------*----------------
quot;tweaclequot; gt; wrote in message
...
gt;
gt; I have a V look up table set up and has a list of stations and cost
gt; centre no's
gt; See below:-
gt; Brondesbury Park 4-2-08-00
gt; Brondesbury 4-2-09-00
gt; West Hampstead 4-2-10-00
gt; Finchley Road amp; Frognal 4-2-11-00
gt; Hampstead Heath 4-2-12-00
gt; Gospel Oak 4-2-13-00
gt; Kensington Olympia 4-2-25-00
gt;
gt; I seem to get some stations ok and others dont come up. I.E I put in
gt; Brondesbury as the station and the offcost code comes up ok. If I was
gt; to put in Gospel Oak for instance it comes up with the value of quot;0quot; or
gt; #n/a. Why is this happening. I have the argument no 4 set to quot;falsequot;
gt; cos I need to have a exact match.
gt;
gt; Can anyone help?
gt;
gt;
gt; --
gt; tweacle