Link to home
Create AccountLog in
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
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of cansevin
cansevin

ASKER

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