INDEX, cells containing text within string, return corresponding values in next column

e45987r, rt4352, fr65830	12Dec10	rt4352
rt7777, fr77321, e87212r	07Aug11
rt4352, fr32121, e00098r	28Feb10

In this example, rows 1 & 3 both contain the string rt4352 in different spots in the cell (there are much more than 3 rows in my actual data).

What I want to do is identify the each cell in column A that contain rt4352 and return the corresponding value from column B. In this case, I want to return 12Dec10 and 28Feb10 (they can be returned in separate cells or the same cell)

I thought I could use the INDEX function with a FIND or MATCH, but I just can't get it. Any suggestions?

Good day,

I assume you need to this only for rt4352

Try this
=IF(ISERROR(FIND("rt4352",A1)),"",B1) for you first set of data in Row#1 and drag down.

Originally Posted by NBVC

You can try something like:

Please Login or Register  to view this content.

adjust ranges to suit... this assumes data is in A2:B100 and the search string of interest is in C2.

The formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down

Thank you! This worked perfectly!