Autofill from Chart

[aberryman]

I want to enter data in a cell (B2) and enter data in another cell (C2). I want D2 to autofill based off of a chart where one axis is the data entered in B2 and the other axis is entered in C2. Hopefully, I explained it clearly. Reference the attachment. The example is a basic one, however, I will be using it for multiple rows and columns.

Thank you for your help.

[Andy Pope]

You could use SUMPRODUCT

=SUMPRODUCT(($H$4:$H$8=B2)*($I$3:$M$3=C2)*$I$4:$M$8)

or INDEX and MATCH
=INDEX($I$4:$M$8,MATCH(B3,$H$4:$H$8,0),MATCH(C3,$I$3:$M$3,0))

Assumes Rank and Year values will match exactly with those in the Row and Column headers of the table.

[aberryman]

Thank you so much. I knew Excel had to have a way, it can pretty much do anything. Thank you again.