How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy Steps)

Рет қаралды 47,153

Күн бұрын

Пікірлер: 35

@Spreadsheeto 11 ай бұрын

👋 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/

@rahulj004 17 сағат бұрын

Thanks for simple and useful video made my life easier

@MrProfilen 10 ай бұрын

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.

@RATHNAMANOJ 16 күн бұрын

థాంక్స్ రా బాబాయ్.. బాగా explain చేశావ్ ! (THANKS BRO... GREAT EXPLANATION. )

@chuzi_shopr 9 ай бұрын

That was very helpful. Clear explanation. Thank you!

@CardCaptor32584 Ай бұрын

Amazing Tutorial. Thank you!

@paulroberts7315 21 күн бұрын

Great explanation, thank you without an irritating voice.

@yeyintwin8574 4 ай бұрын

I have been using INDEX MATCH all my life, but this is the most clear and understandable explaination I have encountered so far. Thanks.

@paulang8267 9 ай бұрын

Marvellous! The way you explain together with your approach in structuring the formula, there is no need to remember the confusing syntax. Thanks

@bushmouse 4 ай бұрын

Just what I was looking for. Very clear explanation of each step.

@Tl2004ever 2 ай бұрын

Very easy to follow! Thank you!

@derrickpeoples1864 7 ай бұрын

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!

@naruhach5566 5 ай бұрын

I love how you explain it in slow explanation and in sequence so I would understand it very quickly, thanks a whole lot sir

@krystalleong8763 6 ай бұрын

Finally been able to make this formula work with your explanation, thank you!

@paulroberts7315 21 күн бұрын

Although you have helped me tremendously explaning this, would it be possible for me to ask a question relating to the use of INDEX/MATCH please

@kasturiranganp 6 ай бұрын

The way you explain is simply brilliant. Many thanks!

@Samantha-ji7iw Ай бұрын

Thank you, thank you!!

@fernandovillaman3580 3 ай бұрын

Great video!

@GeorgeAJululian 3 ай бұрын

Thanks very helpful

@hassanmburia8825 Ай бұрын

Thank you

@sriharsha_10 6 ай бұрын

having an issue. error coming up saying a value used in the formula is of wrong data type. Did the same procedure

@mikaleenmellor9125 3 ай бұрын

I have two drop downs that cooresond to a table. Tax filing status and state reference a table tht lists the individual states in colum B, the income ranges for single in column E and income ranges for married in column H. then the income range needs to reference the earned income greater or less than a specific income to assign the correct tax rate percentage. (Might be best if I do a screen share)

@loidabetances5497 7 ай бұрын

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?

@joshuawalsh9283 10 ай бұрын

Does this only work for Excel 365? I have Professional plus 2019

@Spreadsheeto 10 ай бұрын

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 😊