VLOOKUP in Excel - Explanation with example

What is VLOOKUP: -

Need for VLOOKUP formula: -

• With the help of VLOOKUP, we can retrieve the numbers of exact or approximate matched value in the seconds.
• It helps in saving time and doing work more efficiently.
• it will show the matched value in the column/row where you want. So, we do not need to find the values individually from the selected date and then copy, paste it.

The Feature of VLOOKUP formula: -

1. It works only left to right. It can only look up the value from the Selected cell(Table_array) from left to right side.
2. This formula provides two types of matched value i.e. approximate and exact.
3. VLOOKUP always finds the first matched value from the selected cell(Table_array) and retrieve it.
4. We can use 1 and 0 instead of True and False respectively.
5. It retrieves data based on column number.

Explanation of Formula:-

1. Ture: - Approximate Match
2. False: - Exact Match