Indirect or VLookup result based on multiple 3+ selections

[dagindi]

Happy New Year Everyone:

On the attached sample spreadsheet you will find a simple chart. When I or another user "selects" the 3 criteria (Product, Person & Size) I would like the Result amount to automatically populate.

I know the easy answer is to use change the layout a little by combining Person & Size and then do a indirect but Im hoping to utilize the chart as it is.

Thanks!

[DBY]

Hello
Try the following formula in cell D12.

=INDEX($B$3:$V$8,MATCH(A12,Product,0),MATCH(B12,$B$1:$V$1,0)+MATCH(C12,Size,0)-2)

This appears to return the correct results.

[dagindi]

Perfect!! I am going to work through it to see how it actually works!

Thank you!!!