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

Classic array approach ;)

If your intent was to educate you failed miserably

Definitely informative! It caused me to have more questions though which isn’t a bad thing. I didn’t understand the whole tblSales[Date] in the sense of how you created that and didn’t use F8:F22. I see what you did as being cleaner but I’m just not there knowledge-wise. Do you have a video that explains that part? Thank you!

Hi, how do you do a vlookup with a min formula, but only return the number if it not a 0? Thank you

Total bullshit. I have a historical weekly data set. I need to return an open price at the first week of each month. Can you help me?

Your explanation, style and attention to detail are great.

Thank you. I have watched and liked many of your videos. BUT, I'm trying to learn what your are showing in the formula bar but you have the "name" of reference listed instead of the basic excel range or cell number. That is making it more complicated to follow and learn to write my own formulas. If you are teaching "How to" you can't take the liberty of doing what you would do when YOU write your formulas and use those short cuts. I understand it shows where the info is being pulled.... but it make it more difficult to follow. If I have to go click on a link and learn something to just understand what you are talking about then to just makes to too hard to follow. :(

Very very useful