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

grid

Board Regular
Joined
Dec 4, 2009
Messages
54
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

:)
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Excelestial

Well-known Member
Joined
Jan 2, 2009
Messages
828
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

Board Regular
Joined
Dec 4, 2009
Messages
54
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

:)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,685
Messages
5,597,532
Members
414,152
Latest member
ReservoirDodds

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top