MIN IF Array Formulas with VLOOKUP or INDEX MATCH (Part 2 of 5)
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/
Видео MIN IF Array Formulas with VLOOKUP or INDEX MATCH (Part 2 of 5) канала Excel Campus - Jon
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/
Видео MIN IF Array Formulas with VLOOKUP or INDEX MATCH (Part 2 of 5) канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5)](https://i.ytimg.com/vi/I23Cy8FkMLY/default.jpg)
![INDEX MATCH Explained (An Alternative to VLOOKUP)](https://i.ytimg.com/vi/yH_ArqoB0no/default.jpg)
![How to use AGGREGATE for MIN IF Formulas in Excel (Part 3 of 5)](https://i.ytimg.com/vi/4utkmMTIoXU/default.jpg)
![19 Advanced Excel Shortcuts (do you know them all?)](https://i.ytimg.com/vi/5pwV7ERbXjk/default.jpg)
![Focus On Learning and Creating Rather Than Entertainment and Distraction](https://i.ytimg.com/vi/wlCz8nkDNqo/default.jpg)
![5 More things I wish I Knew When I Started Using Excel VBA](https://i.ytimg.com/vi/v-ETVJ83ivY/default.jpg)
![How to Prevent Vlookup Errors when Inserting or Deleting Columns (#REF! Error)](https://i.ytimg.com/vi/WXO5Ad6dGKo/default.jpg)
![Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT](https://i.ytimg.com/vi/OJLfPc9YlqE/default.jpg)
![10 Amazing (Less Known) Excel Tricks You Should Know](https://i.ytimg.com/vi/KdTSjdUSANw/default.jpg)
![Excel Lookup to Return Multiple Values with FILTER Function](https://i.ytimg.com/vi/Eehk6PC0oGs/default.jpg)
![Power Query Overview - Automate Data Tasks in Excel & Power BI](https://i.ytimg.com/vi/vq9AgAtSvQg/default.jpg)
![Compare Two Lists Using the VLOOKUP Formula](https://i.ytimg.com/vi/GdrOFBBEMQ8/default.jpg)
![Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)](https://i.ytimg.com/vi/9NUjHBNWe9M/default.jpg)
![How to use Excel Index Match (the right way)](https://i.ytimg.com/vi/F264FpBDX28/default.jpg)
![5 Things I wish I knew When I started using Excel VBA](https://i.ytimg.com/vi/DxIzTKgchJ8/default.jpg)
![Google Forms - Formulas in Sheets That Autofill with Submit](https://i.ytimg.com/vi/0v-hQ3EecdE/default.jpg)
![Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646.](https://i.ytimg.com/vi/4qZ8ud8akus/default.jpg)
![Your Excel Printing Problems, Solved!](https://i.ytimg.com/vi/SZBRFRoGSFY/default.jpg)
![How to Merge Tables with Power Query: VLOOKUP Alternative](https://i.ytimg.com/vi/73T7isNVH_w/default.jpg)
![Index Match with Multiple Criteria](https://i.ytimg.com/vi/1lvHjivcjNc/default.jpg)