For many somewhat complicated reasons – it has to do with transposing columns and rows because of third party software limitations, etc. – I have had to use the INDIRECT
function in order to make copying a formula across a range of cells feasible. However, I would like to make the references direct.
Consider the following example:
in which a cell (B2
in the example) contains =INDIRECT(A2)
,
and cell A2
contains the text value B1
.
Thus, cell B2
evaluates to =INDIRECT("B1")
;
i.e., it fetches the value from cell B1
.
Is there anyway to actually change =INDIRECT(A2)
to just =B1
?