Excel Dynamic Cell References

[chifu]

I have a formular in cell A2 which contains a Cell reference eg. =B1 to pick up the value in B1.

I have another cell which contains a number eg. A1 contains 5.

Is it possible to change the formular in A2 so that it picks from a cell according to the number in cell A1.

eg. A1 = 5 so formular in A2 =B5

Could not work out if this is possible.

Many Thanks.

 

[callcentreman]

the formulas you need to use are concatenate e.g.=concatenate("a"+ A1)in cell B1
and then =INDIRECT(B1) in the output cell.

good luck

 

[JillT]

Actually I think what you want is the IF function. This will allow you to set criteria to match to return a value from another cell. For example:

=IF(A1=5,B5,B1)

If the number in A1 equals 5, then return the number or formula in B5, else return the number or formula in B1.

Take a look at Excel Help for more information, or maybe try the Paste Function Wizard.