Returning a word from a list

D

Dan

Column A has 1200 rows, each with about 300 characters of
text, including city name. Column B has a list of about 12
cities. In column C, I want to search column A for the
name of any city in column B, and return that city name in
column C.

How do I go about doing that?
 
J

Jason Morin

One way. Put in C1, press ctrl/shift/enter, and fill down:

=INDEX($B$1:$B$12,MAX(IF(ISNUMBER(SEARCH
($B$1:$B$12,A1)),ROW(INDIRECT("1:12")),-1)))

HTH
Jason
Atlanta, GA
 

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

Index/Match Functions to Return Concatenated Response 4
Drop down lists in seperate columns 5
Extracting a cell value 2
Return a list based on +/- of a cell value 0
Return a list based on +/- of a cell value 0
Return a list based on +/- of a cell value 0
Return a list based on +/- of a cell value 0
Convert list to UPPER, lower & Proper cases. 21

Top