Excel If a Cell Contains a Certain Text (From Another Table)

Mar 12, 2017
Reaction score
Hi There,

I have a very challenging exercise that I want to solve and of course with your help.

My Excel workbook contains two sheets.

Sheet 1 is my main sheet.
The cells in the first column (A) contain all the different codes.
And I am trying to check if this cell contains specific text.
In my example, the codes I am trying to search are listed in sheet 2. (e.g. 736, 739, H01, H05)

Meaning: If a Cell (A2) Contains a Certain Text (e.g. 736 or H05 ...etc.), then Put in cell B2 a Specified Text (Specific Code Name listed in the second sheet)

Sheet 2 contains the table of these codes (source)

And this is the final result that I am trying to achieve.

Would you please help me with which formula I shall use.
the sample excel sheet is attached as well.

Thank you in advance.

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