Lookup for the current month and year value by the today date.

**thilag** · 12-31-2014, 01:23 AM

Hello Friends

File Name : <Date to Month lookup 301214.xlsx>
File Version : Excel 2010

I want to lookup for the current date in Cell D1 to Column A and the corresponding Column B should b filled in Cell E1 yellow cell.

thanks in advance

thilag

**ELeGault** · 12-31-2014, 02:12 AM

=VLOOKUP(D1,A:B,2,TRUE)

Note that since you are looking up NOW() which is an ever changing value you will want to use the Match type TRUE as this is an approximate match against your static values

**thilag** · 12-31-2014, 03:07 AM

Hello EleGault

thanks

thilag

Lookup for the current month and year value by the today date.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Lookup for the current month and year value by the today date.

Re: Lookup for the current month and year value by the today date.

Re: Lookup for the current month and year value by the today date.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to compare date (including month and year) from a listed date to today's date

[SOLVED] Lookup current week using today's date

[SOLVED] Formula for today's date as year month day

Keep month and date but change year to current year and reoccur when new year rolls over.

[SOLVED] Excel 2007 : Convert Today's Date To The Previous Month & Year

Bookmarks

Bookmarks

Posting Permissions