Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to use the following formula:
(VLOOKUP([@Program],Manual_Weaving_Hours_per_Program_Deliverable[[Program]:[Total]],4,FALSE)*INDIRECT(ADDRESS(ROW(INDEX(Table77[Program],MATCH([@Program],Table77[Program],0))),CELL("col")+VLOOKUP([@Program],'Background Tables (New)'!$BC$5:$BD$5,2,FALSE)),TRUE)/('Background Tables (New 2)'!$R$5*'Background Tables (New 2)'!$T$5))
It works fine whenever I hit "Enter". If I go to the reference cell and change the value to 6 instead of 7, the formula will not update until I go back and click "Enter". The cell now shows 6. Whenever I change another cell in the workbook, the value changes back to 7.
I am unsure of what to do.
Essentially, this formula (without the indirect) returns cell AP3 which is correct. But whenever I put the indirect to get the value, the formula stops updating.
I am trying to use the following formula:
(VLOOKUP([@Program],Manual_Weaving_Hours_per_Program_Deliverable[[Program]:[Total]],4,FALSE)*INDIRECT(ADDRESS(ROW(INDEX(Table77[Program],MATCH([@Program],Table77[Program],0))),CELL("col")+VLOOKUP([@Program],'Background Tables (New)'!$BC$5:$BD$5,2,FALSE)),TRUE)/('Background Tables (New 2)'!$R$5*'Background Tables (New 2)'!$T$5))
It works fine whenever I hit "Enter". If I go to the reference cell and change the value to 6 instead of 7, the formula will not update until I go back and click "Enter". The cell now shows 6. Whenever I change another cell in the workbook, the value changes back to 7.
I am unsure of what to do.
Essentially, this formula (without the indirect) returns cell AP3 which is correct. But whenever I put the indirect to get the value, the formula stops updating.