MIN IF Array Formulas with VLOOKUP or INDEX MATCH (Part 2 of 5)

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

In this video you will learn how to combine the MIN IF array formulas with VLOOKUP or INDEX MATCH to return a value from another column. This formula will find the minimum value in a column based on matching criteria from another column.
Download the file: https://www.excelcampus.com/functions...

This is the second video in a series on solutions to the Formula Challenge to find the first sales transaction for each month of the year. There were over 100 solutions submitted on the blog page, so I created a series of videos to explain the most popular solutions.

In the last video I explained how the MIN IF array formulas works.
In this video we combine that formula with VLOOKUP or INDEX MATCH to return the salesperson's name. Either technique with VLOOKUP or INDEX MATCH will work. INDEX MATCH is less prone to errors when columns are inserted or deleted. It can also return values from columns to the left of the lookup column.

In the next video I explain how to use the AGGREGATE function. For that formula we do NOT need to use the Ctrl+Shift+Enter array formula.

Additional links:
#1 Excel Array Formulas Explained with MIN and IF Functions    • Excel Array Formulas Explained with MIN an...  
#3 How to use AGGREGATE for MIN IF Formulas in Excel    • How to use AGGREGATE for MIN IF Formulas i...  
#4 How to use MINIFS to Calculate Minimum Value based on Multiple Criteria    • How to use MINIFS to Calculate Minimum Val...  
#5 How to Use AGGREGATE for MIN IF Formula with Multiple Criteria    • How to Use AGGREGATE for MIN IF Formula wi...  

Calendar System & Dates Explained in Excel: https://www.excelcampus.com/functions...
Beginner's Guide to Excel Tables: https://www.excelcampus.com/tables/ex...
How to Turn Table Formulas On/Off: https://www.excelcampus.com/library/t...
00:00 Introduction
01:15 VLOOKUP Array Formula
06:51 INDEX MATCH Formula