Index and Match Help

[Mohamed Sameer Kazi]

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
Sameer

 

[vletm]

Mohamed Sameer Kazi
how about next...
=INDEX(B5:D5,'Weekly Dashboard'!E$4-13,1)

 

[Mohamed Sameer Kazi]

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

 

[herofox]

Try this equation

=INDEX($B5:$D5,MATCH($E$3,$B$4:$D$4,0))

 

[vletm]

@Mohamed Sameer Kazi
Of course You could change Yourself as below ...
=INDEX(B5:D5,1,'Weekly Dashboard'!E$4-13)

 

[Mohamed Sameer Kazi]

Try this equation

=INDEX($B5:$D5,MATCH($E$3,$B$4:$D$4,0))

Thanks for the code, it solve my issue

u all are great helpers.