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

[@Spreadsheeto]

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

[@MrProfilen]

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.

[@chuzi_shopr]

That was very helpful. Clear explanation. Thank you!

[@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.

[@Tl2004ever]

Very easy to follow! Thank you!

[@bushmouse]

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

[@paulang8267]

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

[@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

[@krystalleong8763]

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

[@derrickpeoples1864]

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!

[@kasturiranganp]

The way you explain is simply brilliant. Many thanks!

[@mikaleenmellor9125]

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)

[@GeorgeAJululian]

Thanks very helpful

[@fernandovillaman3580]

Great video!

[@joshuawalsh9283]

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

[@Spreadsheeto]

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 😊

[@loidabetances5497]

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]

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

[@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!

[@minhajahmed-j7q]

doesnt work it says N/A error ?

[@PRDIGM]

I would like to send you the sample of my spread sheet for you to critique.

[@AnujShresthanpj]

with 3 criteria this formula does not work. can you show the example

[@PRDIGM]

It did not work for me.

[@nuzuliaamini4425]

Hi there, i did the same already but i got N/A

[@megasnaa]

yeah, me too, and then i used the sumifs formula instead to solve the problem

[@roszahirahjohari8752]

@@megasnaa you used sumif for the same exact example he gave? What are you trying to sum? This is a "vlookup" alternative tho

[@calebcali1482]

​@@megasnaa please can you elaborate