Matching a value if a code in a table is within another cell

[MrBKirk]

I need a formula that in column F will search and match a table where Column I's value is within Column A and make F egual to the equivalent value in J.
I've tried search, match and Vlookup to no luck.
Eg,

• I2 is within A2 so B2 should equal to J2
• I3 is within A5 so B5 should equal to J3

 

[Peter_SSs]

You're welcome. Glad we were able to help. Thanks for the follow-up.