running a vlookup off a date

[zilch4ry]

Hi all,

I was just wondering if it is possible to run a vlookup based off of which day of the week it is, for example, if the =now() was to show it was a monday I need all information found in on monday to be shown.

I'm not too sure if =NOW() is the best way to go on this, but any help will be appreciated.

Thanks in advance,

Tom

Every time I try this I receive "#N/A"

 

[Aladin Akyurek]

Try to post a small sample with which to work...

 

[stilesbn]

If you enter =TEXT(NOW(),"dddd") it will return what today's day is.

You could either enter that into a cell or put TEXT(NOW(),"dddd") into your VLOOKUP formula as the lookup value.

 

[ChrisM]

NOW() should work, but you need to get it formatted just like your data. I would assume your data is in dates, 1/1/2011, 1/5/2010, etc, not just in weekdays (Mon, Tues, etc) though...?

But, you say weekdays so here's how to do weekdays:

=Weekday(Now())

That will return an integer, 1 thru 7. Your lookup data must then be formatted in 1 thru 7.

 

[zilch4ry]

thank you all for the answers, I have the formula working