Hi,
I have a question about finding a corresponding rate from Sheet2. Can someone provide a solution? Thank you very much.
Sheet2 is a rate table. "Effective Dates" means "the rate is effective after that date".
Sheet1 is a working table. I need to find the rate from Sheet2 according to "Employer, Effective Date", and "HoursType".
Sheet1 is worksheet, Sheet is rate table.
Sheet1.JPGSheet2.JPG
Bookmarks