#1
|
|||
|
|||
Vlookup error
Hello,
I am doing a vlookup, it seems for some cells it shows what I am looking for, but then I have this #N/A while I should find the matching information. I don't know why Excel cannot find the matches for these cells. The formula is perfectly correct. I cannot seem to figure why. Anyone could help me out? Thank you very much. |
#2
|
||||
|
||||
Or what you are looking for is not present in the 1st column of the lookup range or there is an invisble difference, like non printable characters or one or more space before or after the string.
Eventually post a sheet. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hey thank you, I know why, coz I figured meanwhile. Even a blank space is not acceptable, thanks for your swift response
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automation error Unknown error" message once they open the Excel file | hlina | Excel | 1 | 10-08-2013 09:14 PM |
VLookup is giving me #N/A error, help with data or formula? | ladygogo78 | Excel | 3 | 10-22-2012 12:28 AM |
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!! | bennypryde | Office | 1 | 01-05-2012 03:33 PM |
Runtime error 5487 - Word cannot complete the save to to file permission error | franferns | Word | 0 | 11-25-2009 05:35 AM |
Receive error cannot open this form because an error occurred in BCM 2007 | bornhusker | Outlook | 0 | 06-01-2009 10:28 AM |