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?
Bookmarks