What does a VLOOKUP function do?1. Increases the font of text2. Search

1.	What does a VLOOKUP function do?1. Increases the font of text2. Searches for a value in the column3. Prints the content of an Excel sheet4. Deletes a value in the column
Answer» Correct Answer - Option 2 : Searches for a value in the column The correct answer is an option (2). VLOOKUP Searches for a value in the column VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order to return a value from a different column in the same row. A VLOOKUP function exists of 4 components: The value you want to look up; The range in which you want to find the value and the return value; The number of the column within your defined range, that contains the return value; 0 or FALSE for an exact match with the value you are looking for; 1 or TRUE for an approximate match. Syntax: VLOOKUP([value], [range], [column number], [false or true])

What does a VLOOKUP function do?1. Increases the font of text2. Searches for a value in the column3. Prints the content of an Excel sheet4. Deletes a value in the column

Answer» Correct Answer - Option 2 : Searches for a value in the column

The correct answer is an option (2).

VLOOKUP stands for ‘Vertical Lookup’.
It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order to return a value from a different column in the same row.
A VLOOKUP function exists of 4 components:
- The value you want to look up;
- The range in which you want to find the value and the return value;
- The number of the column within your defined range, that contains the return value;
- 0 or FALSE for an exact match with the value you are looking for; 1 or TRUE for an approximate match.
- Syntax: VLOOKUP([value], [range], [column number], [false or true])