Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup formula fails to return data search item is text
Why does my vlookup formula return N/A when the search item is exactly the
same: i.e. employee name e.g. C J Fourie? I'm running Excel 2003. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup formula fails to return data search item is text
Possibly because it isn't exactly the same. An extra space on the end, for
example, will make it different. Try copying that employee name from the list that VLOOKUP is searching and pasting it in the cell where you have what you called the "search item". Does it now work? Alternatively, what is the fourth parameter (range_lookup) in your VLOOKUP formula? (It helps to always quote the formula when you ask a question here!) From Help: "If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted. You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending." "Delfina" wrote in message ... Why does my vlookup formula return N/A when the search item is exactly the same: i.e. employee name e.g. C J Fourie? I'm running Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can Vlookup formula search for data with two reference | Excel Discussion (Misc queries) | |||
Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
Formula fails in text formatted cell | Excel Worksheet Functions | |||
vlookup fails on data from a pivot table | Excel Worksheet Functions | |||
search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions |