indexing/matching

[chrisatola]

i have a workbook i'm using for payroll. i created it originally in open office, and am now trying to make it for use in excel. i basically am having trouble with the function i need to match the pay (x) AND the deduction status (y) to a value in a range and return a corresponding value from a table.

this sounds confusing, but i've attached an example of the chart i am using.
the formula i used in open office is as follows (for the example, x=7 and y=1):
INDEX(C:E Range;MATCH(x;A Range;1);MATCH(y;Row 1 Range;1))

so that the values indexed comprise of the whole table of amounts, x is the pay, i match x to the A range value (using the matching type that returns the greatest value less than or equal to the specified value), and match y to the row 1 range, and i should return one value. in this case, with x=7 and y=1, the value should be 20. i hope this is clearer than mud, but if not i will try to elaborate.
thanks for the suggested help
chrisatola

[daddylonglegs]

Looks like you have it about right, what doesn't work? Assuming your table starts at A1 then your specific formula would be something like

=INDEX(C2:E4;MATCH(F1;A2:A4;1);MATCH(F2;C1:E1;1))

where F1 and F2 contain the x and y values

[chrisatola]

should i be using the setting on index for "array" or "reference?"
i may be doing something wrong, but i'm still having problems getting a correct answer
any ideas?
thanks

[chrisatola]

nevermind--tinkering with it for a few more minutes gave me the answer i was looking for. i was complicating things. Thanks for the help
chrisatola