How To Put Vlookup In Excel Step By Step

Now the reference to the range is locked and you can move on to the next step by typing a comma.

How to put vlookup in excel step by step. We are about to create a vlookup formula that will retrieve the description that corresponds to the item code in cell a11. However the vlookup function needs to know the entire dataset in order to return the information you want later on in step 4. To do this excel needs a number that corresponds to the column number in the table. Vlookup and hlookup are part of some of the more advanced functions available in excel.

How to do a vlookup in excel learn how in 5 minutes. In cell b11 of course. How to use vlookup in excel learn vlookup step by step our great country india. Interestingly this is the step that most people get wrong.

Tell excel what column to output the data from. The vlookup formula consists of four main parts each of which refers to a piece of information in your spreadsheet. You provide a name or lookup value that tells vlookup in which row or record of the data table to look for the desired information you supply the column number known as the colindexnum of the data you seek the function looks for the lookup value in the first column of the data table vlookup then locates and returns the information you seek from another field of the same record using. You can also directly invoke this function window using the shift f3 shortcut key.

In this step we need to tell excel which column contains the data that we want to have as an output from the vlookup. To add a field to the new table enter your vlookup formula in the first empty column using the information you gathered in step 3. For more details and step by step tutorials on how to use this function and other advanced excel functions sign up for the microsoft excel advanced excel 2010 training course from udemy and learn to harness the power of functions in your worksheets. So select or type range a2 through c55 and press f4 mac.

Understand each aspect of the vlookup formula. Where do we want this description put when we get it. Go to the employee details sheet and place your cursor on the d2 cell salary column row2 and navigate to the formulas tab and click on the insert function block. In our example column g uses attorney the lookupvalue to get the bill rate data from the fourth column colindexnum 4 from the attorneys worksheet table tblattorneys the tablearray with the formula vlookupatattorneytblattorneys4false.