E
Esradekan
I have a workbook for wages.
Each staff member has a sheet of their own calculating gross amounts
paid.
Tax is deducted from this amount but is complicated by the various
"tax Codes"
Column A has the gross amounts paid ($1-$200)
Column B - F is headed by the relevant codes, with tax amounts under.
I need a formula that will look up the cell that has the gross amount
paid, then look for the tax amount under the relevant tax code.
I think its a combination of index/match, just not sure how to do it.
Any helpers?
TIA
Esra
Each staff member has a sheet of their own calculating gross amounts
paid.
Tax is deducted from this amount but is complicated by the various
"tax Codes"
Column A has the gross amounts paid ($1-$200)
Column B - F is headed by the relevant codes, with tax amounts under.
I need a formula that will look up the cell that has the gross amount
paid, then look for the tax amount under the relevant tax code.
I think its a combination of index/match, just not sure how to do it.
Any helpers?
TIA
Esra