V Look Up Function Problems
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
|