Worksheet Reference

[Guest]

I would like the sheet name referenced in a formula to be relative to the
value in another cell. Examples:

If the value in cell A1 is 1 then my formula should be ='1'!B3

If the value in cell A1 is 2 then my formula should be ='2'!B3

Can this be done without programming? If so, how?

 

[davesexcel]

=IF(Sheet3!A1=1,Sheet1!A1,IF(Sheet3!A1,Sheet2!A1,""))

 

[Guest]

Probably INDIRECT ..
Try in say, B1: =INDIRECT("'"&A1&"'!B3")
where A1 houses the sheetname

 

[Guest]

Thanks Max - this is perfect!

Probably INDIRECT ..
Try in say, B1: =INDIRECT("'"&A1&"'!B3")
where A1 houses the sheetname

 

[Guest]

You're welcome, Lynn
Thanks for the feedback ..