Re: Index/Match

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
.