Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a vlookup that is retunring an "#N/A" for one item in a spreadsheet.
I have added a "trim" function to the mix to get rid of extra spaces and it still returns the same. The values in both the cell being looked up and the cell that SHOULD contain the match appear to be the same text to me. Is there a way to determine exactly what is the differences ? Both cells contain text only (or at least that's all that is visible to the naked eye !) Thanks ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
weird phenomenon | Excel Discussion (Misc queries) | |||
vlookup 2nd matching | Excel Discussion (Misc queries) | |||
Help with VLOOKUP or other matching function | Excel Worksheet Functions | |||
Strange phenomenon with General vs. Text formatting | Excel Discussion (Misc queries) | |||
Vlookup with non matching data | Excel Worksheet Functions |