I've already created a named range for the Sales numbers in column F. In this example, we have a table of commission rates on the right and a list of sales numbers in a table on the left. This is useful for things like determining a commission tier based on a sales number, figuring out a tax rate based on income, or calculating postage based on weight.
In this video we'll look at how to use the MATCH function to find approximate matches.
