Hi,
I'm trying to populate a table of data using criteria in Rows and Columns, not sure if Index & Match is the best formula to use, and if it is how to construct it correctly.
Below is how my data sheet looks with the first 2 rows and first 2 columns being criteria, with data in the red. Columns 3 & 4 contain irrelevant data that I want to ignore.
<tbody>
</tbody>
Can I put a formula in a second sheet that matches the criteria in the two columns and the two rows. In the FORMULA cell below it would return the value 14 from the table above.
<tbody>
</tbody>
Thanks in advance,
V.
I'm trying to populate a table of data using criteria in Rows and Columns, not sure if Index & Match is the best formula to use, and if it is how to construct it correctly.
Below is how my data sheet looks with the first 2 rows and first 2 columns being criteria, with data in the red. Columns 3 & 4 contain irrelevant data that I want to ignore.
1 | 2 | 1 | 2 | ||||
A | A | B | B | ||||
105 | X | 3 | 0 | 1 | 1 | ||
105 | Y | 1 | 5 | 14 | 3 | ||
210 | X | 0 | 2 | 9 | 1 | ||
210 | Y | 10 | 0 | 5 | 1 |
<tbody>
</tbody>
Can I put a formula in a second sheet that matches the criteria in the two columns and the two rows. In the FORMULA cell below it would return the value 14 from the table above.
1 | |||
B | |||
105 | Y | FORMULA | |
<tbody>
</tbody>
Thanks in advance,
V.