VLookUp of Dates In Between

cansevin used Ask the Experts™
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!
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You don't need to use the DATEVALUE function as the date in cell C2 is already a real date...

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


You the man... thanks! I feel stupid.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial