How to Use Vlookup for Approximate Matches:

Share Now

Approximate match in Vlookup function help us to find closest result.

Below table showing percentage of commission for salesman’s based on the number of Products sold.  If number of product less than 20 then no commission is given and 20% is given if 80 or more but less than 100 products are sold.

Click here to download the Sample Workbook


Now add one “No. of Product Sold” column in the commission table in ascending Order.


Now applies the vlookup formula VLOOKUP(D7,$H$15:$I$19,2,TRUE) as shown in the below screenshot.

TRUE in the 4th Parameter will return the approximate match. An approximate match returns what Excel interprets as the closest result to what you have looked up.


Share Now
November 15, 2019

0 responses on "How to Use Vlookup for Approximate Matches:"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Tableau Training in Delhi

    All Rights Reserved. EC Analytics Consulting 2014 - 2019.

    NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy