Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-21-2019, 08:05 AM
srsev6 srsev6 is offline Simple Vlookup not working Windows 10 Simple Vlookup not working Office 2013
Novice
Simple Vlookup not working
 
Join Date: Feb 2019
Location: Illinois
Posts: 5
srsev6 is on a distinguished road
Default Simple Vlookup not working

I am trying to use a simple vlookup formula in excel and it is not working. Not sure why.



=IF(VLOOKUP($B2,Sheet2!$A:$AX,26)="","","X")

Basically if the result is blank I want a blank. If the result has a date or text then I want the result to be an X not the actual value (date or text).

I have tried several different versions and nothing is working properly. It is a simple formula so not sure why none of them are working properly.

I have also tried:
=IF($B2="","",IF(ISBLANK(VLOOKUP($B2,Sheet2!$A:$GF ,26,FALSE)),"","X"))
=IF(ISERROR(VLOOKUP($B2,Sheet2!$A:$AX,26,FALSE))," ","X")

Thank you for your help.

Last edited by srsev6; 03-21-2019 at 09:57 AM. Reason: Trying to Delete my Post
Reply With Quote
  #2  
Old 03-21-2019, 09:01 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Simple Vlookup not working Windows 7 64bit Simple Vlookup not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

And which error pops up?
VLOOKUP syntax requires the FALSE ( or 0) parameter to find an exact match...
What do the blank cells contain in reality? The Null string, nothing at all?
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 03-21-2019, 10:00 AM
srsev6 srsev6 is offline Simple Vlookup not working Windows 10 Simple Vlookup not working Office 2013
Novice
Simple Vlookup not working
 
Join Date: Feb 2019
Location: Illinois
Posts: 5
srsev6 is on a distinguished road
Default

The blank cell has nothing at all. I am not getting an error, it is adding an X for the blank cells. The X should be added for a non blank cell and remain blank for blank cells. I have not special characters or any hidden characters in the spreadsheet.
Reply With Quote
  #4  
Old 03-21-2019, 09:56 PM
xor xor is offline Simple Vlookup not working Windows 10 Simple Vlookup not working Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,035
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

All of

=IF(VLOOKUP($B2,Sheet2!$A1:$AX10,26,0)="","","X")
=IF($B2="","",IF(ISBLANK(VLOOKUP($B2,Sheet2!$A:$GF ,26,FALSE)),"","X"))
=IF(ISERROR(VLOOKUP($B2,Sheet2!$A:$AX,26,FALSE))," ","X")

works fine for me.


Edit: Wasn't aware that the problem had been solved.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Not working Properly josepfh Excel 1 04-19-2017 11:04 AM
Simple Vlookup not working Conditional formatting not working with simple formula bendmc Excel 2 11-17-2016 11:31 AM
VLOOKUP not working properly with data digiting, only copy&paste Mike84bs Excel 3 05-06-2015 10:01 AM
Simple Vlookup not working VLOOKUP Formula is not working babs1234 Excel 3 03-04-2015 06:08 AM
vlookup not working jolinchew Excel 3 08-10-2013 05:24 PM


All times are GMT -7. The time now is 11:58 AM.


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