Lookup with two criteria

Needing a formula for cell E7 in a sheet called Game, that will lookup & return data for the criteria in E6 & C7. For example:

In sheet called Game, where E6 shows the phrase "1ST" &
C7 shows the name "Kayla"

The lookup range is in a sheet called Lineup in range G4:ET17
Row 3 contains headings 1st, 2nd, 3rd, etc starting in column G &
Column D contains the names starting in row 4.

Therefore, if cell LineUp!G3 contains the phrase "1ST" &
cell LineUp!D9 contains the name "Kayla" then

cell Game!E7 should return the value in Game!G9 of CF

....A.....B.....C.....D.....F.....G......H.......I
1
2
3...................................1st....2nd....3rd
4...................Amber........RF......CF
5...................Ashley.......Hm......Bn
6...................Brooke.......Bn.......Pt
7...................Destin........Pt.......LF
8...................Hanna........Lf.......RF
9...................Kaya..........CF......Hm

Thanks a million. mikeburg

Wonderful! I tried my own version of index & match & couldn't it to work. But this works greats!

Thanks a lot. mikeburg