Macro roadblock:If cell contains certain text equalling another cell, then post another cell...

[frumpylump]

Hi! I've been putting together a spreadsheet for awhile now and have been able to piece it together up until this point, my knowledge and understanding has run dry.
We're running 2007, have a couple macros working already and creating a tool setup sheet for our CNC department and some tool descriptions have tool holder values like H1 and H33 which stands for E.M. Holder and Thru Coolant respectively and we need to transfer this info from H values to descriptions. I haven't posted the codes I've tried because it's big and messy.

Issue 1: the tool descriptions CONTAIN the H values, the cell does not EQUAL the H values.
Issue 2: row C is where this needs to happen, row B has the tool descriptions, and I have listed the H values in row Q and the corresponding H descriptions in row R

so example:

(A)Tool#	(B)Tool Description	(C)Tool Holder	...	(Q)H Values	(R)H Descriptions
1	T52629 INSERT T58810 H33			H1	E.M. Holder
12	T22537 DEDICATED	DEDICATED		...
20	T14017 INSERT T57705 H1			H33	Thru Coolant

<tbody>
</tbody>

So now we need Thru Coolant in C2 and E.M. Holder in C4 and I just can't figure it out, tried couple things but can't get whole picture.
B range would be from B12:B100, Q and R range 12:54 each.
Thanks so much in advance! I'm going to keep trying to fix it myself but man my head hurts.

*Bonus Question!*
Sometimes there's two H values, how can I have it see row cell B contains both H3 and H33 for example to post both the H values? If i have to create another H value and description that's fine because there aren't many dual H value combinations.