Need help creating a formula

I need to create a formula for returning the tax brackets based on Income.

If value is between 0 and 9225, returns 10%
If value is between 9226 and 37450, returns 15%
and so on

Thanks in Advance

So I understand that the range is D2 to F6 but how does the formula decide to find a value between D and E and return the value in F? I didn't think Lookup would be the appropriate formula because I didn't know how to structure a range to do so. (If the answer is, "It just does", I'm cool with that)

Originally Posted by duncanmc831

So I understand that the range is D2 to F6 but how does the formula decide to find a value between D and E and return the value in F? I didn't think Lookup would be the appropriate formula because I didn't know how to structure a range to do so. (If the answer is, "It just does", I'm cool with that)

Duncan, this may help you understand better:

LOOKUP is referencing the values in the vector of column D. It searches until it can find a match. If it cannot find the lookup_value, then it matches the largest value in the lookup vector that is less than or equal to lookup value. That's why when it searches for "52226" in column D and it cannot find it, it resorts to using the closest match that is less than the lookup value, which is "50001" and it outputs 27%

OK so its not actually looking at ANYTHING in the E column. What you are saying is if it is less than or equal to the value in D (the left most) it returns the value in F (the right most)?

Thank you so much Mr. Valko