Setting a variable

[ltsimmons]

I want to change a letter for identifying a cell
Ex. In cell B2, it says, =(G47) pulling the value from G47
However, I want the letter “G” to change based on a letter from another cell where I am using “IF” statements. So, cell B2, could say, =(G47), =(D47), etc.
How can i have the letter change?

[teylyn]

Hi,

say the formula that determines the letter is in A1, then in B2 use something like

=INDIRECT(A1&47)

hth

[rwgrietveld]

Suppose the letter "G" is in B1:

Please Login or Register  to view this content.

or if the Letters can only be "G" or "D"

Please Login or Register  to view this content.