Index MATCH MATCH where I need 2 vlookups and 1 hlookup.

INDEX(G15:T40, MATCH(B8,G15:G40,0) & MATCH(B1,H15:H40,0),MATCH(G4,F15:T15,0)

My questions is how do I connect the 2 vlookups?is this possible?

Try

=INDEX(G15:T40, MATCH(TRUE,IF(G15:G40=B8,H15:H40=B1),0)MATCH(G4,F15:T15,0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

=INDEX('PLT Projected inbounds MTV SLP'!$F$15:$T$40,MATCH(TRUE,IF('PLT Projected inbounds MTV SLP'!$G$15:$G$40=B8,'PLT Projected inbounds MTV SLP'!$H$15:$H$40=B1),0)*MATCH(G4:I4,'PLT Projected inbounds MTV SLP'!F15:T15,0))

This is the whole formula with what you suggested. I get #REF!

I do confirm but not sure If I do it correctly. Does it matter where the cursor is when I confirm?

I can see an error with the last MATCH in your formula, it should be

=INDEX('PLT Projected inbounds MTV SLP'!$F$15:$T$40,MATCH(TRUE,IF('PLT Projected inbounds MTV SLP'!$G$15:$G$40=B8,'PLT Projected inbounds MTV SLP'!$H$15:$H$40=B1),0),MATCH(G4,'PLT Projected inbounds MTV SLP'!F15:T15,0))

The cursor should be active in the cell when you confirm, meaning you should see the formula in the cell, not the result.

That did it. Thank you.

You're welcome, thanks for the feedback!

If you need to drag this formula to other rows / columns in a table then you might need to make some slight adjustments to that it copies correctly.