Using Excel VLOOKUP Function with Multiple Criteria (Multiple Cells)

Опубликовано: 28 Март 2016
на канале: TrumpExcel
890,521
5.9k

In this video, you'll learn how to use Excel VLOOKUP function with Multiple criteria.

Excel VLOOKUP function, in its basic form, can look for one lookup cell/value and return the corresponding value from the specified row.

But often there is a need to use VLOOKUP with multiple criteria/condition. For example, you may want to use VLOOKUP to find the matching value when the lookup values are in multiple cells.

In this video, I will show you two techniques to use the VLOOKUP with Multiple Criteria
-- Using helper columns and
-- Using the CHOOSE Function.

Both of these methods work well, but I prefer using the helper column method as it's easy and faster. The only downside of using a helper column for doing a multiple cell VLOOKUP is that you have to add an extra column (which is not the case with the CHOOSE array formulas method)

So, instead of just using one cell as the lookup value, you can use Vlookup with multiple cells (i.e., use multiple cells as the criteria in VLOOKUP to fetch the corresponding value)

Read More + Download File: https://trumpexcel.com/vlookup-with-m...

Related Video (Using VLOOKUP function in Excel):    • VLOOKUP Formula in Excel  

Click the link below to Subscribe to the Trump Excel Channel:
https://www.youtube.com/subscription_...




Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

trump excel, vlookup with multiple criteria, vlookup multiple criteria,

#Excel #ExcelTips #ExcelTutorial


Смотрите видео Using Excel VLOOKUP Function with Multiple Criteria (Multiple Cells) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TrumpExcel 28 Март 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 890,52 раз и оно понравилось 5.9 тысяч людям.