Hi guys, I have a question involving vlookup.

I'm currently compiling matchup reports for baseball hitters. As an example, lets say I have pitcher x facing team y. I need to vlookup ALL of the players from team y so that each of their stats show up below pitcher x. I already have a cell range defined for every hitter in baseball, and I need excel to pull each player from team y to the matchup page. I feel like this couldn't be too difficult to do but I haven't yet been able to figure it out.

Thanks in advance for any help.