Worksheet Reference

L

Lynn

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?
 
M

Max

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