Vlookup gives 0 if cell is blank

[vivekshanghvi]

Vlookup returns zero if the particular cell is blank. is there any way by which the result is blank instead of zero.

 

[mtb'r]

Vlookup returns zero if the particular cell is blank. is there any way by which the result is blank instead of zero.

Use an IF statement.
=if(vlookup(A1,B:D,2,0)=0,"",vlookup(A1,B:D,2,0))

 

[Stormseed]

Vlookup returns zero if the particular cell is blank. is there any way by which the result is blank instead of zero.

Hi...try this

For Example if u want the data from coulmn 3 -->
IF(ISERROR(VLOOKUP(A1,1:65536,3,FALSE))," ",VLOOKUP(A1,1:65536,3,FALSE))

take care !

 

[Krishnakumar]

Custom format the cell

0;;

HTH