reference value in a cell

G

Guest

I have these values in sheets.

Sheet2!A1 = 5
Sheet3!A1 = 7

Now, I put Sheet1!A1 = "Sheet2" which can be varied to "Sheet3" or "Sheet4"
etc.
User has to provide the name of the sheet here in Sheet1!A1.

The problem is what formula to put in Sheet1!A3 so that it checks the value
in Sheet1!A1 and depending on sheet name, takes the
value of A1 of that sheet.
Ofcourse it is wrong, but, something like this [Sheet1!A1]![A1]
i.e. if I write Sheet1!A1 = "Sheet3", the value in Sheet1!A3 becomes =7.

Any help is appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF function and cell /sheet reference 3
Code to format cells on several worksheets 2
Removing Intermediary Connections 2
Hyperlink via indirect cell reference 8
Conditional Concatenate? 2
alter code to apply to range (links cells w/ row insertions) 1
If Statement Checking Formula NOT Value in a Cell 7
macro works - very quick 6

Top