VLOOKUP across mulitple rows?

[jimboryan]

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.