Forum Discussion
Solved
Lookup Rotating List from week number
Hi all Hope you can help? This one is probably simple but is bamboozling me..... I have four names: Jane Bob John Martin I need a non VBA method to display based on the 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.
matt0020190 Or perhaps enter in A1:
=WEEKNUM(TODAY())to get the current week number. And in A2, mtarler 's formula, slightly modified:
=CHOOSE(MOD(A1,4)+1,"John","Martin","Jane","Bob")
- Thanks, as per my reply to mtarler can you support?
