Hello,
I'm looking to create a formula that looks up the pay period based on an inputted date.
The trick is that I have 1 table with two different pay cycles on it, so I would want for it to control for which Pay Cycle is being addressed, then look up the date from the relevant pay cycle, and return the pay period number for that date.
In my example, we're looking at Cycle A as indicated by cell B1. The date I'm typing in is cell B2. I would want cell B3 to be a lookup based on the first two rows and the table of dates and pay cycles in columns E-G.
Thank you!
Bookmarks