Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2015, 07:24 PM
lily lily is offline Vlookup error Windows 8 Vlookup error Office 2013
Novice
Vlookup error
 
Join Date: Oct 2014
Posts: 18
lily is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 04-24-2015, 12:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Vlookup error Windows 7 64bit Vlookup error Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 04-24-2015, 01:21 AM
lily lily is offline Vlookup error Windows 8 Vlookup error Office 2013
Novice
Vlookup error
 
Join Date: Oct 2014
Posts: 18
lily is on a distinguished road
Default

Hey thank you, I know why, coz I figured meanwhile. Even a blank space is not acceptable, thanks for your swift response
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup error Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
Vlookup error VLookup is giving me #N/A error, help with data or formula? ladygogo78 Excel 3 10-22-2012 12:28 AM
Vlookup error 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft