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!

Hi,

Are you able attach a copy of your file?

peterrc

Tony,

That returns #N/A as well.

Petrrc,

I've attached a cleaned up version (I had to remove several sheets for proprietary reasons)



I have a feeling that it's something really simple that I happen to be overlooking.

Tony,

Very nice! That works great.

May I ask what the -- does in front of the LEFT function? I've never seen that before.

Tony,

Very nice! That works great.

May I ask what the -- does in front of the LEFT function? I've never seen that before.

Tony,

Very nice! That works great.

May I ask what the -- does in front of the LEFT function? I've never seen that before.