Populate a cell from an address

rsrc1147

Board Regular
Joined
Jul 9, 2002
Messages
100
Hello

I have a formula which produces a cell address (in the form $C$10). Is it then possible to populate the resultant cell (in this case C10) with a number or something using a formula or does it have to be a macro? Eg, the formula produces cell A1 and A1 gets a 1 put in it. The formula then generates address B15 and cell B15 has a 1 put in it.

Thaaaaanks!

James
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
This would be possible in code.
In normal use we cannot *'put'* something in an empty cell with a formula - in this case cell B15 would need to contain a formula.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,169
Messages
5,570,654
Members
412,335
Latest member
cinciri99
Top