Excel Crazy

How to Use Vlookup for Approximate Matches:

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

June 11, 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 *

top
 

© LOKESH PALIWAL 1987 - 2018

LOKESH@EXCELCRAZY[DOT]COM | 8826547882

Reporting Solutions | Data Consulting | Analytics Training

CONTACT US
close slider

Your Name (required)

Your Email (required)

Your Phone no. (required)

Your Message for us...

Skip to toolbar