Avatar of cansevin
cansevin
 asked on

VLookUp of Dates In Between

On attached document, I have Column C of Date Values. On the next sheet titled "Pay Period" I have a table. This table has dates in column A and B.

On Sheet1 Column J, labed "Pay Period". I would like it to find which pay period Cell C2 falls in and result be the value of Column C of Sheet "Pay Periods". I am trying to use the following formula and it is not working:

=VLOOKUP(DATEVALUE(C2),'Pay Periods'!A:C,3,1)

Any help would be amazing. Thank you!
Project09202018.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
cansevin

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Wayne Taylor (webtubbs)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
cansevin

ASKER
You the man... thanks! I feel stupid.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck