Variable Cell Reference

**Tyr@work** · 11-16-2007, 06:43 PM

If this issue has already been addressed, I apologize, but I couldn't find a solution that would make this work, no matter how I played with it. I am newb at excel, but after I RTFM I still have no working solution for this.

Where...

Variable G1; //is a cell containing the name of the worksheet
Variable H5; //is a cell containing the column number of the data cell
Variabel I5; //is a cell containing the row number of the data cell

How do I make it

='G$1'!($H5,$I5)

such that ($H5, $I5) are the coordinates of the cell on the worksheet G1?

without using Macros

Thanks in advannce for your help (and patience).

**Ron Coderre** · 11-16-2007, 06:55 PM

Try this:

Please Login or Register  to view this content.

Is that what you're looking for?

**Tyr@work** · 11-16-2007, 07:53 PM

PERFECT! Thank you!

**UncaLar** · 08-23-2012, 11:12 AM

Thanks Ron! I was not aware of the Indirect function. Worked for me as well.

**oldgnome** · 02-24-2014, 02:49 PM

I have a similar question. I am trying to build a formula that will allow me to copy it to various locations and pick a reference for a cell name.

In the cell for Location 1, I can place the formula =site_name_1 and the correct location name will display. I would like to be able to enter something along the lines of =site_name_&H1, where the cell H1 contains the number 1 and the result in the destination cell will be =site_name_1, resolving to the name of Location 1.

Is this possible?

**arlu1201** · 02-28-2014, 01:23 AM

oldgnome,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.