Using INDEX() and MATCH()

[ajetrumpet]

this is another question from a previous thread here: http://www.mrexcel.com/forum/showthread.php?t=532154

an MVP here gave me this setup for using these two functions:

the formula for the last line, my row, is:

=$J$23+MATCH($M$8,INDEX(LookupData!$B:$B,$J$23):INDEX(LookupData!$B:$B,$J$24),1)

J23 = START ROW
J24 = END ROW
M8 = income amount I'm using

I don't have enough experience to read it and figure it out quick. the table that all these formulas get info from is:

What I'm getting though, is the change of my rates, mandatory tax, ceiling (and so on) ON the ceiling numbers, instead of on the numbers $1 dollar above them. For instance, income of $0 is giving me a rate of 10%, and so on.

I don't know which number to change in the "My Row" formula to get what I need. Basically, the 10% rate should start at $1, 15% should start when income hits $8376, and so on.

Can you guys give me a push again? Thanks!

 

[Gerald Higgins]

What are the numbers in J23 and J24 ?

 

[ajetrumpet]

how about a file instead? I'm not sure how to nail the problem down exactly. It's pretty self explanatory:

www.thefourws.com\forums\excel\taxestimator_test.xls

change the taxable income cell to test whether it works or not. Right now, it does not. It's off a row or two.

 

[Gerald Higgins]

Sorry, I'm not looking at your file.

Can you just tell us what would be typical entries for J23 and J24 please ?

 

[ajetrumpet]

no Gerald, I'm not doing that, because there aren't typical answers. You have to see the table to understand what I'm talking about.

It only takes a minute to look at it, bud, to figure out what's goin on. 2 sheets, 2 inputs.

If you don't look at it, thanks for your help anyway.

 

[Gerald Higgins]

OK sorry, I'm outta here. Good luck.