Index/Match

  • Thread starter Thread starter Esradekan
  • Start date Start date
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
 
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
Click to expand...

Forgot to mention that the gross amounts paid are on their own sheets,
A1 - A26, each row for the fortnights salary. Tax amounts are on the
sheet called "tax"

Esra
 
Forgot to mention that the gross amounts paid are on their own sheets,
A1 - A26, each row for the fortnights salary. Tax amounts are on the
sheet called "tax"

Esra
Click to expand...

AND,

Cell J1 on each sheet contains their tax code.

DUH, doing this in stages arent I, sorry about that.

Esra
 
Back
Top