In Microsoft Excel,the function that looks up a value in a table is ________.
A)AVERAGE(condition 1,condition 2 ...)
B)IF(condition,value if true,value if false)
C)VLOOKUP(value,table range,column number)
D)COUNTIF(range,criteria)

Question

Quizplus · Accepted Answer

The VLOOKUP function is specifically designed to look up a value in a table by searching for the value in the leftmost column of the table and returning a corresponding value in the same row from a specified column.

In Microsoft Excel,the Function That Looks Up a Value in a Table