I need to reference a cell in the following program but can't seem to get this one figured out:
=INDIRECT("'" & $G$1 & "'!" & admin!G$45 & admin!$N2)
Were I want the "45" to be the cell contents of H1.
Thanks for the help in advance!
-EW
What is H1 in this context?
Originally Posted by Bob Phillips
It's a number, in this case it contains the number 45 but this will change from sheet to sheet with a load of cells referencing it.
Last edited by wagnered; 09-12-2011 at 12:06 PM.
I don't get it, you say it is 45, yet you want it to be 45. I think a further explanation of the problem might help.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/excel-prog...n-formula.html
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks