In this lesson, we‘ve learned the following key points:
1. We've introduced the basic use of the VLOOKUP function.
- whose syntax: VLOOKUP(Lookup_value, Table_array, Col_index_num, [range_lookup])
It has four parameters, each of which corresponds to one of the four questions: Who to look for, Where to look, Which column, and How to match.
- The VLOOKUP function can perform exact matching of data or fuzzy matching. These two matching methods depend on the fourth parameter in the function formula, which is [range_lookup]. Enter code 1 for exact matching and code 2 for fuzzy matching.
2. Notes on the VLOOKUP function are as follows:
- VLOOKUP function can only look up to the right, not to the left.
- The lookup value must be unique. The first data is returned by default if there are multiple identical lookup values.
- If the returned result is the wrong logic value #N/A, two issues to consider first. First, the lookup value really does not exist in the source data table. Second, when we pull down to fill the formula, it is possible that a relative reference occurred, causing the Table_array to be position-shifted. Solution: Check the second parameter Table_array and press F4 for absolute reference.
3. Using the MATCH function and VLOOKUP function together to create more convenient effects.