Can I calculate tax percentage deduction based on individual circumstance?

Hi there, I’m having some trouble creating a VLOOKUP (at least that's how I’ve been trying to do it) to deduct a tax percent from an employee.

The breakdown of what I need is as follows:

A percentage deducted from Gross pay depending on an employee’s individual parameter. I need a formula that will search through the list of employees, find out how much of a percentage should be deducted and then display the monetary value.

Attached is the file I am using (Much of the information had to be nulled), any solutions would be greatly appreciated!

If any further explanation is required please let me know!

Thank you.

Hi RAS,

What result you are looking for... ? can you share manually typed results and I'll try to obtain them using formulas.. ? Thx



Regards,
DILIPandey
<click on below * if this helps>

Look at this.

Why do you make it look so easy? Thank you!

Rest assured I'll likely be needing help again in the future!