how to sue If is null and vlookup function

Microsoft Microsoft office excel 2007 ac...
January 10, 2010 at 22:29:45
Specs: Windows XP
the value of my vlookup is "0", it should be nulled on the cell, help please

See More: how to sue If is null and vlookup function

Report •


#1
January 11, 2010 at 05:22:28
Please provide some more info or try this:

Tools...Options...Uncheck the Zero Values box.


Report •

#2
January 11, 2010 at 06:09:43
Hi,

Try this:

=IF(VLOOKUP(D3,F4:G6,2,FALSE)="","",VLOOKUP(D3,F4:G6,2,FALSE))

If the cell, in this example in column 2 of the lookup table is empty, the If function returns "", i.e., an empty text string. If the cell in column 2 is not empty, the IF function runs the second VLOOKUP() function as normal and returns its value.

Regards


Report •
Related Solutions


Ask Question