vlookup part of string...
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
|