What is the purpose of the VLOOKUP function in Microsoft Excel?
A. To find the maximum value in a range of cells
B. To search for a specific value in a table and return a corresponding value in the same row
C. To count the number of cells in a range that meet a certain condition
D. To calculate the average of a range of cells
Answer:B
What is the purpose of the VLOOKUP function in Microsoft Excel?
A. To find the maximum value in a range of cells B. To search for a specific value in a table and return a corresponding value in the same row C. To count the number of cells in a range that meet a certain condition D. To calculate the average of a range of cells