Using TODAY function in a VLOOKUP formula

  • I am trying to put a task rota together; This includes Daily and weekly tasks (those only done once a week)


    Rather than have to manually update who is assigned on a weekly basis I put together a table which basically performs a VLOOKUP and looks at the Thursday of each week, I have the formula:


    =VLOOKUP($F$1+(3-WEEKDAY($F$1,2)+1),$B$56:$J$146,2)


    Where the function =TODAY() is in cell F1, Whilst this works, my question is, is there a way of replacing the F1 reference with the TODAY function in the formula directly?


    I tried just changing it which didn’t work and I appreciate I’m probably using a convoluted way of doing something very simple.


    Thanks in advance for any help.

  • Hello,


    Have you tried :


    =VLOOKUP(Today()+(3-WEEKDAY(Today(),2)+1),$B$56:$J$146,2)


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • That's Great thank you - i didn't put the brackets in after which makes me feel like a massive idiot but thank you, much appreciated.

  • You are welcome ...:wink:


    We all have our tiny moments with some lack of attention ...


    Thanks for your Thanks AND for the Like ..::smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!