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

Approximate

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

Vlookup_Approximate

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.
 

Vlookup



Share Now
May 21, 2015

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

    Drop us a Query

    Call Us: +91 8826547882

    Drop us a Query