• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index and Match Help

Dear All,

Need help

I am trying to show dashboard by selecting week number in weekly Dashboard Sheet, i try to manage but with if statement in "Graph" sheet

which will go very long as week will increase, any shorter way by using index match function.

appreciate you guys support always

many Thanks


hi vletm,

thank you for the response , try the function its not working

given error

when i change the week number in weekly dashboard sheet, my graph sheet to pick up the value as per selected week to show grpah
on weekly dashboard

any other wayout