sheet name in function

[anilrini]

Is there any method available by which i can alter sheetname in a formula depending upon some condition
e.g. Say i have three teams to control. Data regarding each team is available in sheet1 to 3 respectively.
In sheet 4 i have to use value of sheet1 or sheet2 or sheet3 depending upon some criteria in some other cell of sheet4 itself.

Specific example
Cell A1 of each of sheet 1 to sheet 3 has team leader name.
Cell A1 in sheet 4 can have value 1 to 3
I want team leader name in cell B1 (of sheet 4) of team number mentioned in cell A1 of sheet 4.

thanks.

[DGagnon]

Assuming your sheets are named as "Sheet1, Sheet2, Sheet3" otherwise you can modify to suit your team names.

=INDIRECT("Sheet"&A1&"!A1")

[anilrini]

Wonderful

thanks

Assuming your sheets are named as "Sheet1, Sheet2, Sheet3" otherwise you can modify to suit your team names.

=INDIRECT("Sheet"&A1&"!A1")

[snb]

Please do not quote (see the forum rules)