There are always several ways of doing things in Excel - I'm glad you
found a way that works for you, and thanks for feeding back.

The use of a helper column that I suggested earlier is only temporary
- once you fix the values and then paste them back to the original
column, you can delete the helper column.

Pete

On Oct 23, 4:45*pm, wrote:
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