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