Thread
:
How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
View Single Post
#
4
Don Guillett
Posts: n/a
have a look in HELP index for INDIRECT
--
Don Guillett
SalesAid Software
"qatest" wrote in message
...
Here is what I would like to have:
A B
1 B
2 10
Setup a value 'B' in cell A1 and hope to get B2 value "10" in cell A2 -
thought that using ="A1"&2 in cell A2 will work but didn't.....
/QAtest
Reply With Quote