tab reference

[BethB]

I have 4 sheets in my workbook: sheet1, sheet2, sheet3, and master.

On the master sheet I have cell a3 which contains the word sheet1, sheet2, or sheet3 based on a formula

On the master sheet, I want to bring back cell B10 from either sheet1, sheet2, or sheet3, dependent on what cell a3 reads. How do I write the formula so excel understands I am looking for the data tab referenced in cell a3? Normally, if I knew it would be sheet 1, I know the formula would be sheet1!b10, but in this case, It depends on what cell 3 says as to which sheet I should pull from.

 

[dafan]

Use:

=INDIRECT("'" & A3 "'!A3")

 

[Peter_SSs]

Adding an ampersand and changing the cell ref on the other sheet, I think that would be:
=INDIRECT("'"&A3&"'!B10")

 

[BethB]

Fantastic,Thanks for the help - I've never used indirect before, and I can see a lot of use for it.

 

[dafan]

Yes thanks Peter, was a bit too quick there.