Complex Comparison forumula - Help

Hi,

I am having trouble with comparing some information, and the information it compares it to depends on certain string text it contains.

Breakdown:
Profile (This is a string of text and numbers that defines the size and type of steel, beam, column etc.)
Grade (Material the Profile is made off)
Job Grade (The Grade required for the profiles, this is split into sections, Hot Rolled steel will have a grade which will apply for all profiles starting with a prefix of UA, EA, UB etc.)

Problem Example:

If Cell A2 contained a Profile UB310*46, I want a cell to look at a table that will identify it as 'Hot Rolled Steel' which will then compare the Grade to the Job Grade for 'Hot Rolled Steel', if the Grade and Job Grade is the same return Yes, if they do not match return No.

Attached is an excel sheet to help clarify my query in greater detail.

Don't Hesitate to ask if confused in any way.

Good luck and thanks in advance

Rob