Looking at text inside a cell and using a lookup function

I'm trying to get excel to look at the values inside a cell (A2 in my attached example) and compare the second list of 3 alphabet characters to a list on the next tab and then decide if that list of three letters is present and spit out a value in E2. Is there a way to zone in on that area and compare it using a VLookup?

I did some searching but was unsuccessful in trying a few of the formulas I found.

Any help would be appreciated.

Thanks!

So you just want a 0 or 1?

=--ISNUMBER(MATCH(MID(A2,8,3),Classifications!$B$3:$B$9,0))

if you want to actual pull a result from the table

=IF(ISNUMBER(MATCH(MID(A2,8,3),Classifications!$B$3:$B$9,0)),VLOOKUP(MID(A2,8,3),Classifications!$B$3:$C$9,2,0),"")