the value of my vlookup is "0", it should be nulled on the cell, help please

Please provide some more info or try this: Tools...Options...Uncheck the Zero Values box.

Hi, Try this:

=IF(VLOOKUP(D3,F4:G6,2,FALSE)="","",VLOOKUP(D3,F4:G6,2,FALSE))If the cell, in this example in column 2 of the lookup table is empty, the If function returns "", i.e., an empty text string. If the cell in column 2 is not empty, the IF function runs the second VLOOKUP() function as normal and returns its value.

Regards

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History