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

Bassem · #1 03-11-2017, 02:26 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color	jc491	Word VBA	8	09-30-2015 06:10 AM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting	hanvyj	Excel Programming	0	08-28-2015 01:15 AM
Table with text that flows from cell to cell	hwrigley	Word Tables	7	02-18-2014 02:59 AM
Cut Text from one table cell to another	mrayncrental	Word VBA	3	02-09-2014 01:49 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM