UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Microsoft Excel VLOOKUP Function with Multiple Criteria

January 2, 2019

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

Please reload

Recent Posts

Please reload

Archive

Please reload

Tags

Please reload

FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb