I have a payroll spreadsheet that will calculate everything for payroll except the withholding tables.
I want to LOOKUP the withholding determined by the wage amount. Here is the Table: SINGLE Withholding Table.xlsx
The formula also needs to reference the column to indicate the number of withholding allowances claimed.
I've tried the formula below. The wages are calculated in cell E6. I think I may need to add an IF statement, but I'm seriously confused about where to add it.
=VLOOKUP(E6,MarriedWithholding!$B$6:$C$73,MATCHES(E6, MarriedWithholding!$B$6:$C$73, 1), FALSE)
Any help would be appreciated.
Bookmarks