Hi!

=INDIRECT(B2&"!R2")

Biff

-----Original Message-----
I have a team listed in cells B2:B45. I have tabs for
each of these teams.
I want a formula in cells C2:C45 to take the value from
cell R2 from the team
listed beside it. For example, cell B2 is listed as
BOS. I want cell C2 to
take the value from cell R2 in the BOS tab. I think I
use the indirect
formula but I can't get it to work. Thanks for the help.
.