Hi Mangesh,

yes the formula works ta.

what do i do if the cells for the name being inserted are not
continuous.

=IF(ISNUMBER(MATCH("andrew",$A$1:$E$1,0)),VLOOKUP( MATCH("andrew",$A$1:$E$1,0),$A$7:$B$11,2),IF(ISNUM BER(MATCH("abdul",$A$1:$E$1,0)),VLOOKUP(MATCH("abd ul",$A$1:$E$1,0),$A$7:$C$11,3),""))

what is the formula if the cells which "abdul" or "andrew" may go in
are not continous
eg abdul may go in say - A1,B1,D2,D3,D4

do I need two separate formulas

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