Two drop down boxes giving one answer

[Tiger Tim]

I'm new, I know what I want to achieve and that is:
Using a matrix I have two drop down boxes (Column & Row) I then want to choose one thing from each box and then give me the answer. I have thought about the LOOKUP but cannot get it to work with the dropdown boxes. Thought about the INDEX as well.

[AliGW]

Have you tried this?

=INDEX($B$2:$F$11,MATCH(A14,$A$2:$A$11,0),MATCH(A15,$B$1:$F$1,0))

[63falcondude]

Hello and welcome to the forum.

I would remove the parenthesis from column A, edit the data validation for A1 to Car 1,Car 2,Car 3,Car4,Car 5 then try these:

B14 =INDEX(B2:F11,MATCH(A14,A2:A11,0),MATCH(A15,B1:F1,0))

B15 =INDEX(B2:F11,MATCH(A14,A2:A11,0)+1,MATCH(A15,B1:F1,0))