Vlookup (V stands for ‘Vertical’) is an in-built function in excel which allows establishing a relationship between different columns of excel. In other words, it allows you to find (look up) a value from one column of data and returns it’s respective or corresponding value from another column.
When you need to find some information in a large data-spreadsheet, or you need to search for the same kind of information throughout the spreadsheet use the Vlookup function.
Let’s take an instance of Vlookup as:
Company Salary Table which is managed by the financial team of the Company – In Company Salary Table, you start with a piece of information which is already known (or easily retrieved). Information that serves as an index.
Step 1) we need to navigate to the cell where you want to view the Salary of the particular Employee.- (in this instance, Click the cell with index ‘H3’)
Step 2) Enter the VLOOKUP Function in the above Cell: Start with an equal sign which denotes that a function is entered, ‘VLOOKUP’ keyword is used after the equal sign depicting VLOOKUP function =VLOOKUP ()
The parenthesis will contain the Set of Arguments (Arguments are the piece of data that function needs in order to execute).
Step 3) First Argument: the first argument would be the cell reference (as the placeholder) for the value that needs to be searched or the lookup value. Lookup value refers to the data which is already available or data which you know. (In this case, Employee Code is considered as the lookup value so that the first argument will be H2, i.e., the value which needs to be looked up or searched, will be present on the cell reference ‘H2’).
