The example assumes all commissions are 3%, as set in cell H4, the named rangerate.
This is a nice example of how the result from VLOOKUP can easily be used inside another formula.
As the formula is copied down, a total commission is calculated for each amount in column B.
If the commission rate in H4 is changed, all amounts will update.
Note: When doing an approximate match, VLOOKUP assumes the table is sorted in ascending order.
If VLOOKUP finds an exact match, it returns a value from the matching row.
