Match & Index Formula W/ Row Conditions

Hi!

I actually learned how to Index + Match on this forum funny enough.

Basically I have a data set with seperate data but with similiar headings (i.e coloumns and rows).

I started doing Index/Match formulas and just making each formula cover a limited range to ensure no crossover.

I was wondering though if a condition can be put into the formula!

i.e right now its =INDEX(DATA!A9:N16,MATCH('END PRODUCT'!A4,DATA!A9:A16,0),MATCH('END PRODUCT'!D1,DATA!A9:N9,0))

but it should be =INDEX(DATA!A2:N36) except that the matching will see Q1 or VP multiple times so I somehow need to add if the conditions in A9, A18, A26, A32 are the same value as the first page so this formula doesnt grab the first match it sees!

IN SUMMARY - the first green cell on the second tab should be 2 and the second one 3 but having the same formula so i can copy and paste it

Please see attached!

Jeffrey