With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

Saturday, February 3, 2018

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

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).