Recent Posts



Microsoft Excel VLOOKUP Function with Multiple Criteria

Microsoft Excel's VLOOKUP() Function is a very popular and powerful function, but it has some limitations. In the video below, you will learn how to overcome one of these limitations in order to use the VLOOKUP() Function to find a corresponding value based on multiple criteria.

UPDATE: When using the CHOOSE function, make sure you finish the formula by pressing CONTROL + SHIFT + ENTER. The {1,2} is an array. In order to complete the formula as an Array you need to press CONTROL + SHIFT + ENTER

Make sure you download the exercise file so you can follow along: VlookupMultipleCriteria-01