Formula Needed (If,VLookup?)

[Polsy]

Afternoon All,


Just wanna say hey before I start ranting


I've got a question for you guys. I've been racking my brains on it for quite some time.

Basically I'm needing a formula that some how takes a list of data, in this case names and outputs them into a specific cell, easy enough right? Simple Vlookup, but no. I'm needing these names to be output on relevant dates, in this case weekly.

Sort of a rotation type bases, it needs to go through these names (There are 6) and output all six before starting again.


Like I said, its a bit of an **** and its causing me no end of trouble.


Any Help is greatly appreciated

 

[hatman]

Something like this, perhaps?

Book1
	H	I	J	K
10	tom		jane
11	****
12	harry
13	jane
14	polly
15	kelley
Sheet1

Each week, it will rotate to the next person, then start at the top...

=INDEX(H10:H15,MOD(INT((NOW()-DATE(YEAR(NOW()),1,1))/7),COUNTA(H10:H15))+1)

... you can replace now() with a cell, and then try a whole bunch of dates to see how it works...

 

[Polsy]

By jove I think the boys got it!!!


I cant thank you enough mate, my head was about to explode tryin to break down that lil *****.


Cheers Mate

 

[hatman]

Glad it satisfies... I was afraid you might be looking for a RANDOM weekly assignment without repeating... that would have been tougher...