yes that is correct

Based on the sample provided, in column F, copied down...
=A3&B3&C3&D3&E3
then in column G for table 1, copied down...
=IFERROR(VLOOKUP(F3,$F$13:$F$17,1,0),"XXX")
and for table 2, copied down...
=IFERROR(VLOOKUP(F13,$F$3:$F$8,1,0),"XXX")