Index/Match
 

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

Index/Match
 

On Aug 27, 6:32*pm, Esradekan wrote:
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

Index/Match
 

On Aug 27, 6:35*pm, Esradekan wrote:
On Aug 27, 6:32*pm, Esradekan wrote:

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

AND,

Cell J1 on each sheet contains their tax code.

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

Esra

Index/Match
 

On Aug 27, 6:39*pm, Esradekan wrote:
On Aug 27, 6:35*pm, Esradekan wrote:





On Aug 27, 6:32*pm, Esradekan wrote:

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

AND,

Cell J1 on each sheet contains their tax code.

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

Esra- Hide quoted text -

- Show quoted text -

And after all that I worked it out, thannks anyway

(*-*)<
Esra