Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linest function: data selection problems | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |