Hi Al,

Setting up income tax withholding tables in Excel is actually quite simple. Here are the steps you can follow:

1. Open a new Excel worksheet and create a table with the following columns: "Taxable Income", "Tax Rate", "Base Tax", and "Excess Rate". You can find the tax rates and brackets for your state or country online.
   
2. Fill in the table with the appropriate tax rates and brackets for your state or country. For example, if the taxable income is between $0 and $10,000, the tax rate might be 10%, the base tax might be $0, and the excess rate might be $0.10 for every dollar over $0.
   
3. Once you have created your table, you can use the
   Formula:

   VLOOKUP 

   function to reference the correct amount in your payroll worksheet. For example, if you have an employee with a taxable income of $50,000, you can use the
   Formula:

   VLOOKUP 

   function to find the tax rate and calculate the amount of tax owed.
   
4. To use the
   Formula:

   VLOOKUP 

   function, you will need to specify the lookup value (in this case, the taxable income), the table array (the table you created in step 1), the column index number (the column that contains the tax rate), and the range lookup (FALSE to ensure an exact match).
   
5. Here is an example formula you can use in your payroll worksheet: =VLOOKUP(B2,Table,2,FALSE)*B2-VLOOKUP(B2,Table,3,FALSE)
   
   In this formula, B2 is the cell that contains the taxable income, "Table" is the name of the table you created in step 1, 2 is the column index number for the tax rate, and 3 is the column index number for the base tax. The formula calculates the tax owed by multiplying the taxable income by the tax rate and subtracting the base tax.