VLOOKUP across mulitple rows?

We have a spreadsheet that keeps track of team stats during a tournament. We would like the ability to pick a team and create a printed page of their stat info up to that moment. I was thinking of using Vlookup and create the printable page on a new tab, but I don't know how to make it work over multiple rows (maybe it doesn't?). I have not made a format for the page to print from yet so I have a lot of flexibility. Is there a way to do this? Attached is a sample of our current stat program, and as an example I would like to be able to copy all the information for the team "48th ST AC/DC" to a new tab, and print that info on a page to show to the team members.

Have a look at the updated sample and see if it is something you can adapt.

Regards, TMS

That seems to work, but not if I move things around (using cut and paste). It looks like the formula is exactly the same in a number of places. How does it know which data to pull in? This should be perfect as long as there is a way I can move things around a bit

It uses MATCH to find the "base" row for the team. It uses ROWS to calculate an offset from the base row for subsequent rows. And it uses COLUMN to index the relevant column.

If everything lines up with the source sheet it will work fine. Hide rows and columns rather than deleting them.

I get it now. Thank you very much!!

You're welcome. Thanks for the rep.

I finally am getting back to this. I marked it solved based on how the sample worked, but recently I tried to use this with a larger amount of data (see attached) and it errors after the third set of data. If you copy any of the first three team names, it seems to work just fine. If you try to use any team after that you get a series of #REF errors. Any thoughts?