Array Lookup

[Guest]

I have a column of games with a row of stats for each.
I want to look up a specific game and copy the row to
another part of the worksheet.
How do I do this?
A B C D E F
1 Team PA AB Hits Runs AVG

2 Angels 5 4 2 3 .500
3 Braves 4 3 1 1 .333
4 Mariners 5 4 3 2 .750
5 Yankees 4 4 2 2 .500

So in A10 "Mariners" is the value.
I want to look through A2:A5 find "Mariners" then copy
the entire row to another area M1.

Thanks for your help!

 

[Hans]

Put the following formula in M1:
=VLOOKUP($A10,$A$1:$E$5,1,FALSE)
In N1:
=VLOOKUP($A10,$A$1:$E$5,2,FALSE)
In O1:
=VLOOKUP($A10,$A$1:$E$5,3,FALSE)
in P1:
=VLOOKUP($A10,$A$1:$E$5,4,FALSE)

Copy them down, depending on how many rows you want.

Hans

 

[Alan Beban]

Or array enter into M1:R1

=VLOOKUP($A10,$A$2:$F$5,{1,2,3,4,5,6},FALSE)

Alan Beban