Hi Mangesh or others - I have been using the stated formula for a
vlookup. However for this cell ( I will say it as I would say it in
english) if there is "andrew" in the stated cells return the respected
match, however if there is "abdul" in different cells I would like to
return a match based on a different vlookup.

=IF(ISNUMBER(MATCH("andrew",A1:E1,0)),vlookup(matc h("andrew",A1:E1,0),A7:B11,2),"")

many thanks

andrewm


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