Table_array: The range of cells in which the VLOOKUP will search for the lookup_value and the return value. The value you want to look up must be in the first column of the range of cells you specify in table-array. Lookup_value: The value you want to look up. The function panel may seem intimidating with the terms, but it is simpler than it looks. After opening the Functions Arguments dialog box, you have to fill out four pieces of information. You can manually type the function ( =VLOOKUP), add it from the formula tab on the ribbon, or click on the formula bar fx signĤ. There are several ways you can add a formula into a cell. Select cell C2 to insert the VLOOKUP functionģ.
On the Sales by Employee tab, add three columns for employee name, region, and status.Ģ. Here, we will use VLOOKUP toįetch the related information from the pool of data in the second tab, Employee Detail.ġ. It would have been helpful if we can see the name of the employee, the region he/she belongs to, and his/her employment status. In this example, Sales by Employee tab is difficult to analyze just by the Employee ID. You will see the first tab “Sales by Employee” has Quarter-1 revenue information by individual Employee IDs and the second tab “Employee Detail” has information about each employee following their unique Employee
#How to use vlookup in excel 2010 youtube download
Download the sample file and follow along with the example.
#How to use vlookup in excel 2010 youtube how to
Here I will take you through a tutorial on how to use VLOOKUP function. Learning VLOOKUP formula will change your basic approach towards data forever. This makes VLOOKUP unquestionably one of the most useful power-function of Excel. It can also return theĬlosest match to the value being looked up so that each row in the table can represent ranges of values. The table being looked into can be within a different spreadsheet to the one currently being worked on, and this spreadsheet can be shared between multiple VLOOKUP ( vertical lookup) function allows user to look for a specific value in one column of data inside a table, and then fetch a value from another column in the same row.
If we can combine data from multiple spreadsheets into one spreadsheet, we can save hours of time and reduce data entry errors dramatically. It will be much easier if both sets of data are on the same tab.
Microsoft Excel has a very powerful function that helps users combine data from multiple sources into one table in a spreadsheet.įor example, if you have January’s budgeted sales data in one tab of a spreadsheet and the January’s actual sales data in a separate tab on the same spreadsheet or a different spreadsheet, it would be cumbersome to analyze the budgeted VLookup, one of the most powerful functions for any Microsoft Excel user
0 kommentar(er)
