Re: Index/Match

On Aug 27, 6:39 pm, Esradekan <Esrade...@xxxxxxxxx> wrote:
On Aug 27, 6:35 pm, Esradekan <Esrade...@xxxxxxxxx> wrote:





On Aug 27, 6:32 pm, Esradekan <Esrade...@xxxxxxxxx> wrote:

I have a workbook for wages.
Each staff member has a *** 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
*** called "tax"

Esra

AND,

Cell J1 on each *** 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
.