Lookup problem?

[Mike]

I need a way to select the appropriate commission rate based on the
number of units sold.

My table looks something like this:

Min Max Rate
5,000 9,999 5%
10,000 14,999 6%
15,000 & up 7%

So if the # of units falls anywhere between 5000 & 9999, the formula
should use 5%. What's the best way to do this since its not an exact
match?

Thanks for the help.

Mike

 

[Jim May]

With your table in A1:C4 (header in Row1)
Enter the Sales amt in F1
In G1 enter

=VLOOKUP(F1,$A$2:$C$4,3,TRUE)

 

[Mike]

Cool, thanks for the post!