PTQuoc
Reputation: 1083
Excel offset - referencing other sheet
In my "Scenario Summary", at cell B6 (I move the formula to cell H10 just to make it easier to see), I want to enter formula such that:
- Go to sheet "Project Valuation"
- Then in sheet "Project Valuation" go to cell D12 and get the value in cell D12 (offset 2 columns from F12)
I am trying to use Offset function but a little suck in linking sheet. How should I fix this?
Or is there any better solution?
Upvotes: 0
Views: 22
Answers (0)
Related Questions
- How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
- How do I properly clean up Excel interop objects?
- Excel offset where reference is to another worksheet
- How to create a string or formula containing double quotes in Excel?
- Return a value from another column and sheet using MATCH
- Excel formula that combines MATCH, INDEX and OFFSET
- Excel: Indirect() - Populate summary sheet from other named sheets in spreadsheet
- Offset cells in Excel on different Sheets
- Excel: Copy every nth line from one sheet to another
- EXCEL Formula in master sheet