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

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History