=if(A53="","",vlookup(index(f52:f61,(match(a53,e52 :e61,0))),h52:i61,2,false)
)

Mangesh



"andrewm" wrote in
message ...

Hi,

I have a formula which works except that if a cell(a53) is blank I get
a n/a value. How can I make the value be blank when the value in a53 is
blank as well.

the formula is -

=vlookup(index(f52:f61,(match(a53,e52:e61,0))),h52 :i61,2,false)

if a53 is blank the cell result is n/a

thanks


--
andrewm
------------------------------------------------------------------------
andrewm's Profile:
http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=385168