Thread: [Solved] Simple Vlookup not working
View Single Post
 
Old 03-21-2019, 09:56 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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