On second sheet, assuming Season number in A2 on sheet 2, and Season is
in column B in sheet1, in B2 enter

=INDEX(Sheet1!A:A,MATCH($A$2,Sheet1!$B:$B,0))

and drag across as many columns as you need. This will pull everything
fron the matching row in sheet1, including the Season. You can delete
this column on sheet 2 if you wish.

If this is a frequent occurrence and you have thousands of rows in
sheet1, you could separateout the MATCH function into its own cell and
then refer to it from the INDEX formulas. Say you put it in X1,

X1: =MATCH($A$2,Sheet1!$B:$B,0)

B2: =INDEX(Sheet1!A:A,$X$1)

That will be a little more efficient, at least a few milliseconds.
Heck, a millisecond here and milllisecond there and soon you're talking
big time ...


HTH

Declan


--
DOR
------------------------------------------------------------------------
DOR's Profile: http://www.excelforum.com/member.php...o&userid=29088
View this thread: http://www.excelforum.com/showthread...hreadid=490341