![vlookup in excel 2016 step by step with example vlookup in excel 2016 step by step with example](https://support.content.office.net/en-us/media/e9b96547-1530-41fb-9eb2-c53c55aaa298.png)
If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. The final result in cell H4 is 100, which is the value for Orders for Product ID 1001 with color Blue. Orders is in the fourth column of the table_array so col_index_num is 4. Enter the formula: = VLOOKUP(H2&H3,B2:E7,4,FALSE)įor the lookup_value, we link H2 and H3 ( H2&H3 ) using the “&” AND logical operator. To use VLOOKUP with multiple criteria, we follow these steps: Entering the formula for VLOOKUP with multiple criteria We want to retrieve the value for orders for Product ID “1001” and Color “Blue”.įigure 4. Modified source data in using VLOOKUP with multiple criteria Using VLOOKUP with Multiple Criteria We insert a column “Lookup Value” to the left of the “Product ID” column, where we link the values of columns “Product ID” and “Color”.įigure 3. In order for us to lookup into two columns, we need to add a helper column in the lookup table.
![vlookup in excel 2016 step by step with example vlookup in excel 2016 step by step with example](https://i.ytimg.com/vi/5dTpWmcImpA/maxresdefault.jpg)
VLOOKUP in Excel is limited to handle only one lookup value, which is always in the first column of the lookup table. In cell G4, we want to retrieve the value for orders for Product ID “1001” and Color “Blue”. Sample data in using VLOOKUP with multiple criteria
![vlookup in excel 2016 step by step with example vlookup in excel 2016 step by step with example](https://www.howtogeek.com/wp-content/uploads/2016/02/invoice_database.png)
Vlookup in excel 2016 step by step with example how to#
How to Use VLOOKUP with Multiple Criteria