Salary Bracket returns employees corresponding Contribution for philhealth

[cmaesi]

Hi everyone! i've got a pretty mindboggling task ahead of me and i want to ask for your help.


I have this table which has employees names with basic pay and contribution.
I was tasked to create a excel sheet where in if the employees basic pay is input, the corresponding contribution for the employee will show depending on which salary bracket he/she is on.

Im not allowed to know what my workmates salaries are since im just an associate, so i just have to leave em blank and wait for my manager to input their salary.

please help me. im running out of ideas. please see attached file for the workbook