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?



=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.