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

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/formula-challenge-first-sale-each-month/

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 https://youtu.be/I23Cy8FkMLY
#3 How to use AGGREGATE for MIN IF Formulas in Excel https://youtu.be/4utkmMTIoXU
#4 How to use MINIFS to Calculate Minimum Value based on Multiple Criteria https://youtu.be/pGvQnCJxEt4
#5 How to Use AGGREGATE for MIN IF Formula with Multiple Criteria https://youtu.be/NJFCd3HimXc

Calendar System & Dates Explained in Excel: https://www.excelcampus.com/functions/how-dates-work-in-excel/
Beginner's Guide to Excel Tables: https://www.excelcampus.com/tables/excel-tables-tutorial-video/
How to Turn Table Formulas On/Off: https://www.excelcampus.com/library/turn-off-structured-references-table-formulas/
00:00 Introduction
01:15 VLOOKUP Array Formula
06:51 INDEX MATCH Formula