# VLOOKUP to return value if date falls between two dates

1. ## VLOOKUP to return value if date falls between two dates

Good Morning group,

I feel like I must be missing something obvious here but I seem to be overlooking it. I thought this would be pretty simple. I've tried to find a solution on the web and in this forum with no luck.

I have a column (F) in a Table that holds a date in each cell (all formatted as "short date").

I have a column (I) in that same Table that I would like to show in which quarter that date falls.

I have the following reference Table (named "Dates") on a separate sheet that looks like the attached jpg.

I tried the following formula that I thought would work, but it keeps returning #N/A: =VLOOKUP(F2,Dates,3,FALSE)

I don't know what I'm missing.

So if anyone can either show me what I'm missing here or give me an alternate solution, it would be great!

2. ## Re: VLOOKUP to return value if date falls between two dates

Try replacing False for True and see if that gives you the expected result

3. ## Re: VLOOKUP to return value if date falls between two dates

http://www.excelforum.com/excel-form...two-dates.html

There are currently 1 users browsing this thread. (0 members and 1 guests)