Saturday, February 3, 2018

yogi_Compute Applicable Hourly Salary For Pay Period From Table OF Hourly Salary By Date

Google Spreadsheet   Post  #2360

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-03-2018
question by shimoda
I am looking for a way using ARRAYFORMULA to get an employee last pay rise to calculate his next pay check. The goal is to find the last pay rise effective before the beginning of the pay period. I want to use ARRAYFORMULA in order to avoid copying formulas down the sheet.

I have not found an example where ARRAYFORMULA allow to retrieve a value when searching for a text value (employee name) and the BEST matching date that would fit inside a time interval (so not an exact date match value). 

I would be happy to read your suggestions.