value of indirect cell

C

ccyarm

When I type a reference in a cell, i would like to change the value o
that referenced cell.
Ex: I type "d4" in cell "n5". I would like then to enter "1" in d4.
Is it possible without using vb code?
Thanks
 
M

MrShorty

Depends on details that you haven't given. An example that would d
what you ask would be to have the formula in D4 =IF($N$5="d4",1,0).
This formula could be copied and adapted to any number of cells. I'
not certain exactly how, but the conditional could be adapted to mak
it easier to copy it around (using some combination of ROW and COLUM
functions or other manner).
This method may not be adequate for everything you could possible wan
to use it for. For example, d4 will only hold the value 1 as long a
n5="d4". Once you change the value in n5, d4 will revert to 0 (o
whatever you decide is a more appropriate value_if_false argument).
More details about what you want the spreadsheet to do would hel
develop a more appropriate approach if this one isn't good enough
 
Top