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
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

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    Address

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    Featured Testimonial

    Hi, my...Read more

    Pooja (BI Analyst)

    Make My Trip

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED