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.