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