Forum Discussion
Solved
How to pull out dynamically values from a day and previous day from table simultaneously
Hello, I need assistance for this. I created a dashboard to track power and energy Consumption with daily, weekly and yearly summary. However i have one challenge to achieve my final result as shown...
In E9:
=IFERROR(INDEX(INDIRECT($P$14),MATCH(Sheet1!B9,INDIRECT($Q$14),0),MATCH(Sheet1!$C$6&Sheet1!$C$7&Sheet1!$C$8-1,INDIRECT($R$14),0)),"-")
Fill down to E17
In E9:
=IFERROR(INDEX(INDIRECT($P$14),MATCH(Sheet1!B9,INDIRECT($Q$14),0),MATCH(Sheet1!$C$6&Sheet1!$C$7&Sheet1!$C$8-1,INDIRECT($R$14),0)),"-")
Fill down to E17