How to use vlookup in excel 2010 youtube

#How to use vlookup in excel 2010 youtube how to
#How to use vlookup in excel 2010 youtube free

The lookup value should be a concatenation of the two criteria you want to include in the VLOOKUP. This is often a thing you already know, for example, the name of the employee (column A) and his department (column B), while the thing you donвЂ™t know (in this case) is the salary (column C).Д¬reating an Excel VLOOKUP multiple criteria is to change the lookup value in the function.

The вЂlookup_valueвЂ™ is what you are looking for, but not what you want as a result. STEP 2: Enter the first argument вЂ“ lookup_value STEP 1: We enter the VLOOKUP function in the blank cell where we need to extract the data =VLOOKUP( The things you need to put into a VLOOKUP formula to make it work (also called the syntax) is quite straightforward. Insert a column after column B and name it whatever you want in cell C1.Д®nter the following formula into cell C2 and copy it down to the rest of the rows in the data. In this example, and in the sample file, we need to make a separate column that conjoins the data from the вЂ EmployeeвЂ™ column and the вЂ DepartmentвЂ™ column. That means that before we can go any further in the lookup, we need to conjure up a helper column that joins the вЂTable_arraysвЂ™. The concatenation will in this example be done with the ampersand (&). The basics of using VLOOKUP with multiple criteria scenario is that you will concatenate the different criteria so you can use them as a single lookup value.

#How to use vlookup in excel 2010 youtube free

*** Watch our video and step by step guide below with a free downloadable Excel workbook to practice ***

#How to use vlookup in excel 2010 youtube how to

Want to know how to use Excel VLOOKUP Multiple Criteria? But before you read on you should really know how to use вЂVLOOKUPвЂ™ the вЂњnormalвЂќ way. In this article, I will guide you to how you can actually create an Excel VLOOKUP multiple criteria.В It is an alteration of the typical way of using вЂVLOOKUPвЂ™ and is as intuitive as it is easy to use.

However, this is not as easy and intuitive as using a simple вЂVLOOKUPвЂ™. It is customary to change to the more flexible combination of functions, вЂINDEXвЂ™ and вЂMATCHвЂ™ and turning the formula into an array formula. This means that they would have two criteria for the search (вЂNate HarrisвЂ™ and вЂSales-departmentвЂ™).Д«y default, вЂVLOOKUPвЂ™ cannot help with a two-criteria (or more) lookup.

Instead, they would want to search for вЂNate HarrisвЂ™ but only in the вЂSales-departmentвЂ™ of the company. So if they would be searching for a вЂNate HarrisвЂ™ in an employee database, they would not want to search the entire database. Not necessarily because they know how to use it, but because some savvy Excel-user always talks about it at the office.ДЄdvanced users have seen the use of Excel VLOOKUP multiple criteriaВ to what the function is looking for. вЂ VLOOKUPвЂ™ is now so common that everyone who has ever been working with Excel has heard of it.