Hi Pete

Thanks!!

But instead creating 1 more column I used to following formula...

= IF(ISERROR(INDEX($F$11:$F$20,MATCH("*"&A11&"*",$E$ 11:$E$20,0),1)),
INDEX($F$11:$F$20,MATCH(A11,$E$11:$E$20,0),1),INDE X($F$11:$F
$20,MATCH("*"&A11&"*",$E$11:$E$20,0),1))

Which is returning appropriate result.

Thanks a lot for all your inputs... you rock!!

--milind