Vlookup using (3) Variables, pulling data from another sheet.

[XxCALLofBOOTYxX]

What im trying to do is get the data entered in Yellow to pull from another sheet and supply me with the data requested/needed to fill in the Green cells. I believe this would be appropriate for a VLOOKUP to be used however maybe INDEX & MATCH would be a better choice.
The actual example file is shared here, just hit the download icon in the top right: https://drive.google.com/file/d/1BAp6Lb22BLxYB2o6SPZREWghl7A0kI8T/view?usp=sharing

 

[Aladin Akyurek]

Try to post directly here the data (in a scaled-down form) instead of providing an outside link. That said:

In C8 of Sheet1 in Google Sheets enter and copy down to C9:

=arrayformula(index('Sheet 2'!$C$3:$T$26,match(1,if('Sheet 2'!$A$3:$A$26=$C$5,if('Sheet 2'!$B$3:$B$26=$C$6,1)),0),match($C$7&" GA",'Sheet 2'!$C$1:$T$1,0)+($B8="max lift:")))

In C8 of Sheet1 in Excel control+shift+enter, not just enter, and copy down to C9:

=INDEX('Sheet 2'!$C$3:$T$26,MATCH(1,IF('Sheet 2'!$A$3:$A$26=$C$5,IF('Sheet 2'!$B$3:$B$26=$C$6,1)),0),MATCH($C$7&" GA",'Sheet 2'!$C$1:$T$1,0)+($B8="max lift:"))

By the way rename Sheet 2 as Sheet2 in agreement with Sheet1.