Forum Discussion
Lookup Rotating List from week number
matt0020190 i updated my sample sheet to have a ThisWk cell and a YouPick cell and the corresponding names. i used the exact same formula as B2 but instead of the array $A$2:$A$53 I just point to the WkNumber of interest. Note: that formula is 'overly complicated' in that it doesn't assume how many people are in that list.
mtarler thanks so much for your help and your time. Excellent!
It is pretty much what I am after except creating the list.
I was hoping to feed the formula from a specific week number to output the name. E.g.
Cell A1 =WEEKNUM(TODAY(),21)
Cell A2 = formula to display the name for the relevant week number in cell A1
Of course the above would follow the logic set out in your example where I can define a specific week number for the starting name.
I tried a vlookup but it ruins the list you created in A/B columns. What am I missing, I guess its what you mentioned about an unique index?
matt0020190 i updated my sample sheet to have a ThisWk cell and a YouPick cell and the corresponding names. i used the exact same formula as B2 but instead of the array $A$2:$A$53 I just point to the WkNumber of interest. Note: that formula is 'overly complicated' in that it doesn't assume how many people are in that list.