If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|