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.

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

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.

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.