Finding similar issues in a large excel dataset

Hi all experts,

I have a dataset composed of thousands row and several columns. Please take a look at the attached sample file. One of these columns (B) is called “Description” and another (E) is “symbol”; actually, one of the words in the contents of “Description” column is similar to “symbol”, bolded in sample file. I would like to find a corresponding symbol and put that symbol in front of a cell that contains a “symbol” word (like column C). Could you please help me out to do this work?

Thank you in advance

You can put this array* formula in C2:

=INDEX(E$2:E$12,MIN(IF(ISNUMBER(SEARCH(E$2:E$12,B2)),ROW(E$2:E$12)-1)))

then copy down.

*Note that an array formula needs to be committed using the key combination Ctrl-Shift-Enter (CSE), instead of the usual < Enter >.

Hope this helps.

Pete

=lookup(1e+99,search(e$2:e$12,b2),e$2:e$12)

Thank you very much for both replies, they worked fine. I approved both of them.