#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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?
__________________
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
|
|||
|
|||
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.
|
#4
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Vlookup Not working Properly | josepfh | Excel | 1 | 04-19-2017 11:04 AM |
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 |
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 |