Cell referencing in formula
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. H1 is just a nuumber, in this case it's 45 but will change over many sheets.
Thanks for the help in advance!
-EW
Are you concatenating 2 results?
i.e.
=INDIRECT("'" & $G$1 & "'!admin!G"&H1)&INDIRECT("'" & $G$1 & "'!admin!$N2")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Wagnered,
please try to have some variation in your thread titles, they are all the same and will certainly not help keep the forum easy to use
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks