Excel payroll work

Hello,


I'm using Excel to do payroll system.

e.g.

I create worksheet that showing data as below table :-

basic more than 0.01 less than 10.00 = 0
basic more than 10.01 less than 20.00 = 3.00
basic more than 20.01 less than 40.00 = 6.00
until 20,000.00

I using a code for my table as (1) for more than 0.01 less than 10.00 = 0.... till 20,000.00 and created 300++ code for the table

for my calculation when my basic showing 10.50 should show as 3.00 if more than 20.01 showing 6.00

now I using a formula =LOOKUP(A1,data!A4:A805,date!D4:D805)...A1 was the column to add code, so that not very useful for my payroll work. every time the basic changed I need to refer the table that I create and get the code.

how do I create a formula when I changing my basic then my data can read the value as need?