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


Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 01:20:00 -0800, zunw wrote:

Mike,

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

Tools/options/view/Zero values




"Mike H" wrote:

Perhaps

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

Mike

"zunw" wrote:

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?