You: Will the result be "ABC"?
Me: I don't understand what you mean. Please provide another example, or
restate you initial example.
You: I am trying to come up with a formula that will show the data from cell
A23 in cell A99 using a reference to cell A23 with "A" as fixed and "23" as
the variable found in cell B12.
Me: I think this is what I did, right. Did you try it?
Well, here is another idea. Put the name of your sheet in cell A1.
Assuming the sheet is named 'Sheet1', use this function anywhere (except A23
or B12):
=LEFT(A23,1)&INDIRECT("'" & A1 &"'!B12")
Good luck,
Ryan---
YGSBill said:
Hi ryguy7272
Sorry...I do not understand...will the result be "ABC" as that is what I am
looking for?
Maybe I was not very clear in what I am trying to do. I am trying to come
up with a formula that will show the data from cell A23 in cell A99 using a
reference to cell A23 with "A" as fixed and "23" as the variable found in
cell B12.
Thank you
ryguy7272 said:
Maybe this:
=LEFT(A23,1)&B12
A simple recorded macro yields this:
Range("A99").Select
ActiveCell.FormulaR1C1 = "=LEFT(R[-76]C,1)&R[-87]C[1]"
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
:
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?