How to use VLOOKUP to search for approximate values in Excel

In my last blog post, I discussed how to use VLOOKUP in Excel to find an exact match if a cell, which can be read here:- https://tracyrenee61.medium.com/how-to-use-vlookup-in-excel-565997743528

In this blog post I intend to use the VLOOKUP formula to find an approximate match.

The big difference between finding a perfect match and an approximate match is the last hyperparameter of the formula. For instance:-

1. To find a perfect match, place FALSE in the last hyperparameter of the formula.
2. To find an approximate match, place TRUE in the last hyperparameter of the formula.

In order to illustrate how to use an approximate match using VLOOKUP, the first thing to do is to design a lookup table.

In this example I have made a lookup table that tells how much of a discount a person will get based on the quantity of items ordered. Column E is the amount ordered and column F is the discount awarded:-

The next step is to place the order quantity in column A. I have randomised the quantity ordered by placing the following formula in…