T
Tom_uk
Hi all,
I cant seem to get this to work properly.
(see below)
I have a list of dates, firstly the 5 previous days then the weeks previous
to that. Next to some of these dates will be an action - this can change
depending on the project. The idea is to have a prompter tell me what the
next action is due depending on the day eg. last friday i completed C, now
its monday and D is due this coming thursday.
Everytime i do a VLOOKUP all i get is the first action despite what date i
reference to!
current date: TODAY() eg. 10/05/09
A B
1 28/05/09 security passes due
2 21/05/09
3 14/05/09 email guest list
4 07/05/09 send out rsvp
5 31/04/09 finalise colourscheme
next action: "email guest list"
Is this possible?
I cant seem to get this to work properly.
(see below)
I have a list of dates, firstly the 5 previous days then the weeks previous
to that. Next to some of these dates will be an action - this can change
depending on the project. The idea is to have a prompter tell me what the
next action is due depending on the day eg. last friday i completed C, now
its monday and D is due this coming thursday.
Everytime i do a VLOOKUP all i get is the first action despite what date i
reference to!
current date: TODAY() eg. 10/05/09
A B
1 28/05/09 security passes due
2 21/05/09
3 14/05/09 email guest list
4 07/05/09 send out rsvp
5 31/04/09 finalise colourscheme
next action: "email guest list"
Is this possible?