- VLOOKUP is an abbreviation for 'Vertical Lookup.' It's a function that tells Excel to look for a specific value in a column (the so-called'table array') in order to return a value from another column in the same row. The VLOOKUP function will be demonstrated in this article.
- A VLOOKUP function is made up of four parts:
- The value you're looking for;
- The value you're looking for and the range in which you're looking for it;
- The number of the column that carries the return value inside your selected range;
- For an exact match with the value you're looking for, use 0 or FALSE; For a close match, use 1 or TRUE.
- VLOOKUP is the syntax ([value], [range], [column number], [false or true])
Read More: What is the use of a macro in excel?
