Pulling 2 different data points from data set and returning value - MatchIndex? Vlookup?

[AFIOF719]

trying to pull data to be returned to the report tab from the data tab.

For example, in cell D8, trying to return data based on different combinations of cells D5,D6, & D7.

Let me know if anyone is able to help and/or if you need more info as to what i am trying to do.

[63falcondude]

Try this:

D8 =INDEX(Data!$D$4:$AA$18,INDEX(MATCH($C8&D$5,Data!$B$4:$B$18&Data!$C$4:$C$18,0),0),MATCH(D$6&D$7,Data!$D$1:$AA$1,0))

You can then copy and paste this formula to the other 7 cells.

[AFIOF719]

Great!! thanks

[63falcondude]

You're welcome. Happy to help.