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

[Bassem]

Hi There,

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

My excel workbook contains two sheets.



The first sheet 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, codes I am trying to search for are H01, H02, H03 ...etc.)
Meaning: If a Cell (A2) Contains a Certain Text (e.g. H05 ...etc.), then Put in cell B2 a Specified Text (H Code Name listed in the second sheet)


The second sheet contains the table of these H codes (source)



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




Would you please help me in this.
the sample excel sheet is attached as well.

Thanks