CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Bhavani
Bhavani

Reputation: 27

Excel Cell showing the formula text instead of its value

I'm referring the A10 cell value in an excel file say "D:/Sample.xlsx" from another excel file using the formula "='C:[Test.xlsx]Sheet1'!B10". It works fine and gives me a value say 10 in A10 of "D:/Sample.xlsx" excel file. In the same way when I try to input "C:/" path in C10 of the "D:/Sample.xlsx" file and tried "=CONCATENATE("=", "'",C10,"[Test.xlsx]Sheet1'!B10")" formula in A10, instead of showing the value of the formula (10), it is just showing the text. Can anyone help me with the same. Thanks in advance.

Upvotes: 0

Views: 819

Answers (1)

René Nyffenegger
René Nyffenegger

Reputation: 40499

You are looking for the indirect function.

Returns the reference specified by a text string. References are immediately evaluated to display their contents

Note that the other file has to be open.

Upvotes: 0

Related Questions