View original (French)

Nested formula / VLOOKUP and IF(ISBLANK)

Solved
Fayu -  
 Fayu -
Hello,

So here’s my formula:

If F5 is empty, then nothing; otherwise, search in the data range and return the corresponding value from column 3.

=IF(ISBLANK(F5),""),(VLOOKUP(F5,'base 2017-2018'!$A$1:$H$366,3,FALSE)).

But I would also like it that if the cell in column 3 is empty, the cell with the formula remains empty instead of showing a 0.
Can anyone help me?

Thank you in advance.

3 réponses

Réponse 1 / 3
chewwe1602 Posted messages 49 Status Membre 1
 
Or you can also go to the options and uncheck the box for displaying the value 0

The path:
File>options>advanced options>scroll down to spreadsheet options and uncheck "display a zero in cells that have a null value"
1