I looked at your example.

Format cells C8:C10 as percent so to correlate to the sales percent.
Title these as Minimum or whatever as a reminder. Only enter the
minimum needed for the bonus, don't enter a range.

Formula in cell H7 is then =VLOOKUP(G4,C8:D10,2)*D4

Without having the last argument (True or False) in the Vlookup the
table C8:D10 must be sorted ascending as the Vlookup will return the
value in the range D8:D10 that corresponds to the largest value in
C8:C10 that is less than the value found in cell G4.


--
DCSwearingen


------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=467483