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!
Bookmarks