Index/Match

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
 
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

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
 
E

Esradekan

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

AND,

Cell J1 on each sheet contains their tax code.

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

Esra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top