VLOOKUP Function (Hide Zero Value)

[Jay]

Hello,

I use a Lookup function on my spreadsheets, but some
values are zeros. How can I change this formula:

=VLOOKUP($B59,INDIRECT($B51),32,FALSE)

So that if it results in a zero, I see nothing?

Thank you,
Jay Gustafson

 

[Don Guillett]

have a look in HELP index for IF function

 

[Guest]

Jay,

The most straightforward thing I can think of is to use an if statement such as:

=if(VLOOKUP($B59,INDIRECT($B51),32,FALSE)=0,"",VLOOKUP($B59,INDIRECT($B51),32,FALSE))

It's ugly and verbose, but should work.

Art

 

[Jay]

Art,

It most definitely is ugly & verbose, but it most
definitely works. Thank you very much for taking the time
to solve this. I appreciate it.

Jay