-2

I want to put this

="'Other Sheet'!C"&D5

(where D5 = 1432)

in a cell and get the actual value the formula refers to rather than the formula as a string (current result). How can I do that?

Improve this question
0

1 Answer 1

Reset to default
0

Try

=INDIRECT("'Other Sheet'!C"&D5,TRUE)
Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.