close
For example if I would type, say, quot;A1quot; into a cell, for example B1, could I
then somehow extract the value A1 from B1 and use that information to point a
function at A1?
I think you want the INDIRECT function.
Example:
A1: 21
B1: =quot;Aquot;amp;ROW()
C1: =INDIRECT(B1)
B1 will output the text string quot;A1quot;
C1 will output 21.
quot;Jon Squot; wrote:
gt; For example if I would type, say, quot;A1quot; into a cell, for example B1, could I
gt; then somehow extract the value A1 from B1 and use that information to point a
gt; function at A1?
全站熱搜
留言列表
