Using Dropdown Menu to adjust Xlookup formula

[Tim418]

My desire here is to be able to select a team and game number from dropdown lists, and have the corresponding pitcher show up.

So for example, if I select Yankees, then Game 23, I'd like Bouton to appear under the pitcher column, as Bouton is the player appearing in the corresponding cell.

I'm using XLookup but can't figure out how to make it so that the dropdown menu selection changes the return array.

Maybe there is a different or easier way of doing this.

[Limor_OP]

Hi
Try this:
=INDEX($E$2:$N$37, MATCH(B2,Game,0), MATCH(A2,$E$1:$N$1,0))

[wk9128]

C2 cell formula