Formula to do this :if A3 contains text from G3:G4 then return text from H3:H4 into B3

[PerriLori]

Hi help needed for categorising large range of data.

I need a formula that will do the following
Excel sample.jpg


A B C D E F G H
1 Data Lookup table
2 Description Return here Contains Return What I want the formula to do
3 June BIM 2020 eg PTO BIM PTO if A3 contains text from G3:G4 then return text from H3:H4 into B3
4 DTB June eg SWEEP DTB Sweep if A4 contains text from G3:G4 then return text from H3:H4 into B4

I need to be able to drag down a formula that will return what I need like a vlookup would

[CRIMEDOG]

How many options are in the Lookup table? the problem is - column A is not a standard format.
where does the data come from? if you are entering it keep the 3 letter options at the front or the end.
For example =vlookup(Left(A3,3),G3:H4,2,False)

The problem you have right now - Left A3 returns Jun