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
If you are on Excel with dynamic arrays, that could be
=IFERROR(INDEX(INDIRECT($P$14),MATCH(B$9:B$17,INDIRECT($Q$14),0),MATCH($C$6&$C$7&$E$8:$F$8,INDIRECT($R$14),0)),"-")