👋 3 ways I can help you! 1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com 2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/ 3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/
@yeyintwin8574
Күн бұрын
I have been using INDEX MATCH all my life, but this is the most clear and understandable explaination I have encountered so far. Thanks.
@bushmouse
3 күн бұрын
Just what I was looking for. Very clear explanation of each step.
@naruhach5566
Ай бұрын
I love how you explain it in slow explanation and in sequence so I would understand it very quickly, thanks a whole lot sir
@MrProfilen
6 ай бұрын
Hello, thank you for this video. It was so hard to find the answer to this since I didn't know how to word it. Worked perfectly and now I even understand how these functions work.
@paulang8267
5 ай бұрын
Marvellous! The way you explain together with your approach in structuring the formula, there is no need to remember the confusing syntax. Thanks
@derrickpeoples1864
3 ай бұрын
Thank you so much, Spreadsheeto! That was the exact formula I needed for my lookup at work. You are a God-send! Keep on doing what you're doing, man!
@krystalleong8763
2 ай бұрын
Finally been able to make this formula work with your explanation, thank you!
@kasturiranganp
2 ай бұрын
The way you explain is simply brilliant. Many thanks!
@chuzi_shopr
5 ай бұрын
That was very helpful. Clear explanation. Thank you!
@loidabetances5497
3 ай бұрын
Can this formula be used to find a value within a min/max amounts line in two columns, with one match criteria, to return a value from a table array?
@sriharsha_10
2 ай бұрын
having an issue. error coming up saying a value used in the formula is of wrong data type. Did the same procedure
@joshuawalsh9283
6 ай бұрын
Does this only work for Excel 365? I have Professional plus 2019
@Spreadsheeto
6 ай бұрын
This guide works for ALL versions of Excel. But if you don't have Excel 2021 or newer, you must press Ctrl + Shift + Enter when you're done with the formula instead of just Enter 😊
@andymillard5692
Ай бұрын
I cant seem to get the function to work with the “1”. Is this version specific? I am using excel 2016
@andymillard5692
Ай бұрын
I added an additional index to handle the array…. Works!
@PRDIGM
2 ай бұрын
I would like to send you the sample of my spread sheet for you to critique.
@PRDIGM
2 ай бұрын
It did not work for me.
@nuzuliaamini4425
4 ай бұрын
Hi there, i did the same already but i got N/A
@megaisnaeni6348
2 ай бұрын
yeah, me too, and then i used the sumifs formula instead to solve the problem
@roszahirahjohari8752
2 ай бұрын
@@megaisnaeni6348 you used sumif for the same exact example he gave? What are you trying to sum? This is a "vlookup" alternative tho
Пікірлер: 22