can anyone help me to solve this. i have this timeline with machine and weekly schedule.
and after that I want to make a dashboard automatically that will show us the machine that have “1” on the same week with the week on dashboard. I already try to use vlookup and index match but still dont get it.
Thank you
I already try the vlookup and index match but stil cant have the right result. Thanks
Arkan Jabbar Khairuman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3
This formula maybe does what you need: /requires 365/
=TOCOL(IF(CHOOSECOLS($A$4:$XX$100,MATCH($D$9,3:3,0))=1,$C$4:$C$100,1/0),3)
In D9 there is the week number looking for.
The formula is in cell C11. Replace $XX$100 with the bottom right cell of the table. Also replace in $C$100 the last row value of the table.
2