VLOOKUP function
 

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?

VLOOKUP function
 

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?

VLOOKUP function
 

If your Vlookup range contains Blank then this could help

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

"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?

VLOOKUP function
 

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?

VLOOKUP function
 

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?