How to refer to a sheet in the workbook when the name of the sheet is a value in a cell

Hi,

I got a table consisting of name of sheets in the workbook. Depending on different criterias I have created a formula to choose which sheet to look up data.

The problem is: how can I refer to a sheet in a formula in excel, when the name of the sheet I want to refer to is a value in cell E7 (for instance).

Just to clarify:

Lets say the sheet I want to look up is called "Fruits", i.e. the value in cell E7 is "Fruits".

Instead of writing 'Fruits'!A1 (e.g.) in the formula, I want to refer to the value in E7 (+A1)

Any suggestions? :-)

Thanks in advance!

This should do the trick:

=indirect("'"&E7&"'!A1")

Originally Posted by robertswart

This should do the trick:

=indirect("'"&E7&"'!A1")

Thank you very much @robertswart! Works perfectly!