This question already has an answer here:

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?

marked as duplicate by Rubén, Community Nov 2 '16 at 10:14

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.



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

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