I'm trying to get Excel to fill in a table with values based on the Headings of its Rows & Columns. The source data is in a list in another table.
Basically I want to get the price of the products from TAB 2 into the first table.
Easier would be a sumproduct in B2
=SUMPRODUCT(Sheet2!$C$1:$C$8*(Sheet2!$A$1:$A$8=$A2)*(Sheet2!$B$1:$B$8=B$1))
Drag it across your entire table.
Assuming you first Tab is called Tab1 and second tab is called Tab2 and your tabs start at A1.
You can easily do this with INDEX-MATCH:
In tab1 B2 enter the following
INDEX($C$1:$C$8,MATCH($A2&B$1,'Tab2'!$A$1:$A$8&'Tab2'!$B$1:$B$8,0))
After entering this press Ctrl+Shift+Enter to enter it as array formula. Afterwards you can drag the formula to the rest of tab1.