I use indirect to get a value that I want to calculate with the value of the current workbook

[grid]

Hello,

I use the following formula: =1-B6/B7

This formula calculates the difference of 2 values. This percentage is returned.

Using the formula with INDIRECT do I get data from another worksheet from another workbook.

I use this formula: =INDIRECT("'[Workbook.xls]" & Sheet1!E72 & "'!C2")

This formula gives just the value of C2 of the other worksheet of Workbook.xls

I want a formula that calculates between C2 of the external worksheet of Workbook.xls and B2 that is the current value of the current Worksheet that is not external. I want to return the percentage this way like: =1-C2 other workbook/B6

I want to call the other external workbook the same way as I do with the formule above I have given with INDIRECT.

Could somebody help me?


Best regards,

grid

 

[Excelestial]

Indirect is not necessary. You may reference the external worksheet directly. Indirect is necessary when you want to execute a calculation that has a formula (or any part of it) in a remote cell. Operative word..."formula."

 

[grid]

Hello Excelestial,

It is because I need the sheet name to get called from a worksheet of the
workbook where I work. This is INDIRECT.


Best regards,

grid