📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!


    Question

    In MS Excel, the 'VLOOKUP' function is primarily used

    to:
    A Create a pivot table Correct Answer Incorrect Answer
    B Find a value in a table based on a lookup value Correct Answer Incorrect Answer
    C Calculate the average of a range Correct Answer Incorrect Answer
    D Perform conditional formatting Correct Answer Incorrect Answer
    E Create a chart Correct Answer Incorrect Answer

    Solution

    The VLOOKUP (Vertical Lookup) function is used to search for a value in the first column of a table range and return a value in the same row from a specified column. Its syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). It is extensively used in finance for tasks like matching data from different lists.

    Practice Next
    ask-question