|
|
#1
03-21-2019, 08:05 AM
|
|||
|
|||
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 
|
| 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 |
 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 |
Windows 10 
Office 2013
Threaded Mode