What is the VLOOKUP Function?
The VLOOKUPfunctionin Excel is used to find something in a table.
The result here is22.
Since the formulas are referencing cells and not a specific text string, we can leave out the quotes.
Since VLOOKUP doesn’t need to find an exact match,approximate_matchis left blank to indicateTRUE.
If an exact match isn’t found, the function uses the next smaller amount.
Column F is the final price when the discount is figured in.
TheXLOOKUPfunction is similar but works in any direction.
