How to look up text within a text string?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
sumproduct - find text in string 11
Searching the formula (not the value) for a text string 1
Match a text 4
Count Instances of Text in String Q 6
lookup a value within a text string 5
Need to extract certain text from text string 4
finding text and performing a calculation 1

Top