What is vlookup function in excel?

Asked 25-Mar-2022
Viewed 272 times

1 Answer


0

  • 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?