VLOOKUP function

[Guest]

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?

 

[Guest]

Perhaps

=IF(C1="","",VLOOKUP(C1,A1:B100,2,FALSE))

Mike

 

[Guest]

If your Vlookup range contains Blank then this could help

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

 

[Guest]

Mike,

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

Tools/options/view/Zero values

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP