These are: ‘lookup_value’, ‘table_array’, ‘col_index_number’ and. When inputting the =VLOOKUP, Excel will display the needed values you will need to supply for the function to perform accurately.

Input =A2&B2 into cell C2 and copy this to all the succeeding cells. Insert a new column after B and name it as defined by your purpose in cell C1. In line with this, we will need to join the ‘Table_arrays’ by creating a helper column.įor this demonstration, we will create a distinct column to combine the data in the Employee and Department columns. Using the ampersand (&) symbol, we can input all the criteria within the syntax. To do this multiple criteria VLOOKUP, all the desired criteria must be compressed into the main function. The demonstrations are done using Microsoft Excel 2016 (Windows) but the general concept can be used universally across other versions of the program. In the following example, steps on customizing a VLOOKUP function with multiple criteria are discussed. Most people use it with a combination of other functions such as Match and Index to deliver desired results. The default characteristic of the VLOOKUP function is that it cannot have a lookup with two or more criteria.

Those users who already have an advance understanding of this function have utilized it by putting an additional criterion for search purposes. Microsoft Excel’s VLOOKUP function is a popular feature amongst office personnel and data processor positions.

How to create vlookup in excel 2016