=INDIRECT(F1&"!A"&B12)

With Sheet2 in F1 and 23 in B12





On Thu, 18 Jun 2009 01:15:01 -0700, YGSBill
wrote:

Thank you soooooo very much. Sometimes its the simple things that seem to
trip me up and you have helped me tremendously.

While on the subject, would you know how I would add the following to the
formula...assume that cell A23 is in Sheet2 and I am working in Sheet1...

If I put the text "Sheet2" in an empty cell on Sheet1 or reference Sheet2
directly, what would be the syntaxii used?

Again

Thank you

"Tim Williams" wrote:

In A99:

=INDIRECT("A" & B12)

Tim


On Jun 16, 1:49 pm, YGSBill wrote:
I am new to Excel programming and have run into a problem.
I will try to describe as best as I can:

Cell A23 has text "ABC"
Cell B12 has formula which results in the number 23

What I would like to do in cell A99 is "=A23" where "A" is fixed and the
"23" comes from cell B12. In other words it would look something like this:
=A(B12)

The above does not work...even if I convert 23 to text.

Any suggestions?