New RBI Grade B 2025 Notification will come Soon! Enroll Here

    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. Correct Answer Incorrect Answer
    B VLOOKUP requires the lookup value to be in the first row of the dataset. Correct Answer Incorrect Answer
    C VLOOKUP can look up data in any column and return a value from any column in the dataset. Correct Answer Incorrect Answer
    D VLOOKUP can look up data in any column and return a value from any column in the dataset. Correct Answer Incorrect Answer
    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. Correct Answer Incorrect Answer

    Solution

    Explanation: VLOOKUP (Vertical Lookup) is used in Excel to search for a value in the first column of a range or table and return a value from a specified column to the right of the lookup column. It is particularly useful when you have a large dataset and need to search for a value and retrieve related information.  

    Practice Next