VLOOKUP function

Z

zunw

When using the VLOOKUP function the search cell is blank, the destination
cell is getting a "0". Can this be changed so the destination cell will be
blank also?
 
C

claude jerry

If your Vlookup range contains Blank then this could help

=IF(VLOOKUP(D1,A1:B4,2,0)=0,"",VLOOKUP(D1,A1:B4,2,0))
 
Z

zunw

Mike,

Thx for your help. On an other place I found the answer:

Tools/options/view/Zero values
 
G

Gord Dibben

Which is not a good idea if there are cells which should show a zero.


Gord Dibben MS Excel MVP
 
Top