How to look up text within a text string?

  • Thread starter Thread starter Xlund
  • Start date Start date
X

Xlund

Hi,

I'm having trouble with a formula that requires to look up a text valu
within a given text string and then returns a corresponding value fro
another column.

Here's the formula I'm using:
=INDEX(E5:E177,MATCH("toronto",B5:B177,0))

The formula works fine if the value that is being looked up is unique
i.e. one of the cells in column B only contains the text "toronto".
However, if I need to look up the name of a city in a cell tha
contains multiple city names, the formula no longer works. For example
if I need to look up the text "toronto" in column B and the tex
"toronto" is now grouped in a cell together with the name of anothe
city, e.g. "toronto, madrid", the formula stops working.

Could someone please help me find a way to get around this :confused:
Thanks
 
Back
Top