How do you match one cell to the selections made in two drop down menu's?

This one is a little complex top explain, but in effect i want an entry to appear in one cell that is dependent on the selections made in two different drop down menus

On the attached:

One drop menu is in cell N4, and the other in cell M9

So taking cell G16 as an example,

I want the value there to show the entry from cell P62 if the options chosen in the drop down menu's are AB and With Legs
but i want the entry to match what is in cell R71 for example if AC and Face Fix is chosen

I assume this is done using VLOOKUP rather than the MATCH command? But i cant get my head round how to get it to compare two separate entries to look up a third?

Does it need tabulating differently or a table creating to make this work?

many thanks for any help on this one!

your data in the look up table is in a painful format
if you added the type by the side of the components in say column t in each row
in u62 copied down =S62&T62

then in g16
=INDEX(P62:R139,MATCH(E16&N4,$U$62:$U$139,0),MATCH(M9,$P$61:$R$61,0))

however E16 needs to be stringer, not stringers

Yes : i suggest to revise your tables to have a single table with added column "TYPE" ("AB","AC" etc)

Looking at the table the only difference appear to be GEN-FAB-xx01-10 where xx is AB, AC etc

This is the "lookup" with current tables:

=INDEX($P$62:$R$67,MATCH($E$16,$O$62:$O$67,0),MATCH($M$9,$P$61:$R$61,0))

Change "Stringers" to "Stringer"

Two other options;

A single table, with each type as a named range (file has named ranges for AB and AC)

OR a "common" table (see O118 onward) called "All_rng")

For 1st option

in G16

=INDEX(INDIRECT($N$4&"_Rng"),MATCH($E$16,INDEX(INDIRECT($N$4&"_Rng"),0,1),0),MATCH($M$9,Hdr_rng,0))

or

In G18

=SUBSTITUTE(INDEX(All_rng,MATCH($E$16,INDEX(All_rng,0,1),0),MATCH($M$9,Hdr_rng,0)),"XX",$N$4)