Question

You are given a dataset of product IDs and their corresponding prices in an Excel sheet. You need to retrieve the price of a specific product by looking up its product ID in the dataset. Which of the following statements is correct regarding the usage of the VLOOKUP function in Excel?

A VLOOKUP can only return values from the first column of the dataset.
B VLOOKUP requires the lookup value to be in the first row of the dataset.
C VLOOKUP can look up data in any column and return a value from any column in the dataset.
D VLOOKUP can look up data in any column and return a value from any column in the dataset.
E VLOOKUP requires the lookup value to be in the first column of the dataset, and it can return values from any column to the right of the lookup column.
Practice Next

Hey! Ask a query