Excel VLOOKUP Function

VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right.


=VLOOKUP (value, table, col_index, [range_lookup])

VLOOKUP has two modes of matching: exact and approximate, which are controlled by the 4th argument, called “range_lookup”. Set range_lookup to FALSE to force exact matching, and TRUE for approximate matching.

Example of Exact Matching:

Assume a list is given wherein in 1st Column has name of students and in column 2 their respective CTC is given. The task is to use V look up to find out the CTC for a particular student.

Example of approximate matching:

Assume a store has an offer going on that depending upon the total purchase value, the customer will be offered a discount. The task is to match the discount applicable for each customer depending upon the sales volume.

Refer below table:

Use the Vlookup formula as shown in cell E22 & Simply drag to get the desired result

Be the first to comment

Leave a Reply

Your email address will not be published.