What is vlookup function in excel?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 25, 2020

 

In simple words, the VLOOKUP function in Microsoft Excel states: =VLOOKUP(what item needs to be looked up, where you want to search for, column number in the range containing the value to return, return an approximate). VLOOKUP can be employed when you need to find things in a table or a range by row. To exemplify, look up the price of an automotive part by part number, or find an employee name based on their ID.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Microsoft Excel Interview Questions

    What is Microsoft Excel?

    Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organ..

    Microsoft Excel Interview Questions

    Explain the spreadsheet.

    Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells...

    Microsoft Excel Interview Questions

    What do you mean by ribbon?

     The topmost area on the Microsoft Excel that contains menu and other toolbar items are known as ribbon. CTRL+ F1 key..