Vlookup Return Mutiple Results

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.

Hi,

Not quite clear on your data or its layout, but I'm hoping this example that I have put together is enough to get you started at least.

Let me know