TayariHub
HomeComputer ScienceWhat is the function of the VLOOKUP function in...
Computer Science Medium
Question

What is the function of the VLOOKUP function in Excel?

A
To perform a vertical lookup and return a value based on a specified criteria
✓ Official correct answer
B
To perform a horizontal lookup and return a value based on a specified criteria
C
To add up a range of cells
D
To find the average of a range of cells

Community credibility

Registered members can vote for the answer they believe is correct today and explain why. If the facts change after an election or news event, suggest a new option so others can vote it up.

A
To perform a vertical lookup and return a value based on a specified criteria
Official option

No member explanations yet for this option.

B
To perform a horizontal lookup and return a value based on a specified criteria
Official option

No member explanations yet for this option.

C
To add up a range of cells
Official option

No member explanations yet for this option.

D
To find the average of a range of cells
Official option

No member explanations yet for this option.

Related Questions

Q
The maximum margins can be set in MS Excel are ____________?
Medium · Computer Science
Q
Which function allows to define names/text in formulas except the use of selecti...
Medium · Computer Science
Q
How to split a single columns’ text into multiple columns?
Medium · Computer Science
Q
Which of the following is the common language for Artificial Intelligence?
Medium · Computer Science