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.

Syntax

=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 1^{st} 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

## Leave a Reply