Index match with multiple criteria | excel multiple columns match

💻Get the working file from below link:
1drv.ms/x/s!Atp4jU_zIYb9gXcGq...
1drv.ms/u/s!Atp4jU_zIYb9ah69r...
Discover how to use the INDEX MATCH function in Excel to perform multiple criteria matches in this tutorial. Learn step-by-step how to search for data across multiple columns and retrieve the corresponding values using this powerful formula combination. Whether you're a beginner or an experienced user, this video will provide clear examples and explanations to enhance your Excel skills. Follow along and master the art of multi-criteria matching today! #ExcelTutorial #IndexMatch #MultipleCriteria #ExcelFormulas
Excel sheets related to Basic to Advanced Excel Skills are available for practice,
Click and get the Excel Files from OneDrive.
1drv.ms/f/s!Atp4jU_zIYb9aq0z2...
Contact for learning Excel.
WhatsApp number
[phone]
Donations are much appreciated.
UPI/Bhim Number
[phone]
This helps support the channel and allows us to continue to make videos like this.
Thank you for watching this video, please share this video to your friends and family and support our channel!
📱For connecting on social media
📱Facebook: / sivakumar.rj
📱LinkedIn: / sivakumar-rj-53607021
#ExcelIndexMatch #IndexMatchMultipleCriteria #ExcelMultipleColumnMatch
#ExcelDataLookup #ExcelDataAnalysis #matchmultiple #indexmatchmultiplewithoutarray
#excelindexmatchwith3criteria #complexlookup #howindexmatchworks
#lookup #indexmatchmultiplecriteria #matrixlookup #lookupmultiplecolumns
#matchfunction #matchmultiplerows #LearnExcelFormulas #ExcelTips
#ExcelTipsandTricks #ExcelAdvancedformulas #Indexmatch
#indexmatchmatch #Excelonlinetutorial #Excel #AdvancedExcel #indexformula
#ExcelAdvancedFormulas #ExcelFormulaTips #ExcelFormulaTricks
#ExcelDataManipulation #ExcelDataMatching #ExcelDataLookupFunctions
#ExcelDataFiltering #ExcelDataValidation #ExcelDataAnalysisTechniques
#ExcelIndexMatchTutorial #ExcelIndexMatchExamples
#ExcelIndexMatchExplained #ExcelIndexMatchTricks
#ExcelVLOOKUPAlternative #ExcelArrayFormulas #excel #tutorial #excelformulas #indexmatch #vlookup #exceltricks #exceltips

[@Fxingenieria]

Excellent !!!

[@alegomso]

You just saved me over 8 hours of manual work lol. Thanks!

[@user-gd2bd7gh5o]

Thank you so much! I didn’t know you could do the “ &”combination for multiple criteria a much better shortcut!!

[@sayak01]

Thanks....

[@rajeshshah6758]

Your explanation was so simple. Thank you.

[@bluexwisteria8037]

You saved our lives, sirr! Thankss❤

[@sudmudmud357]

Thank you 🙏… god bless you

[@adsjectivemedia9200]

Thank you so much,this is really helpful :)🙏

[@agape13]

thank you very much! 🏆🥇

[@Serfos1]

Many thanks!!

[@divyalakshman2109]

really helpful! thank you

[@RJSivakumar]

You're welcome!

[@kynesilagan2676]

thank you, short clip!

[@rahulvinod3441]

Thank you so much for this.
It’s perfectly working but showing error in some cells. Could you please help me with that.

[@RJSivakumar]

And function gives result only when it meet all conditions. If any condition is not met with then it will not show result.

[@maduraiquickcooking3824]

Excellent

[@RJSivakumar]

Thank you for support

[@ravirajwal5593]

Thnaks my issue is resolved

[@RJSivakumar]

Thanks for watching video👍

[@br31woodlands69]

Nice video

[@RJSivakumar]

Thank you very much

[@wasimakram11]

Its awesome, same thing can you explain for an example include date instead of code.

[@RJSivakumar]

Yes, sure. Lets hope another video.

[@johnw9269]

Hi, your video is really informative and easy to understand. But what if I have another scenario whereby my match involves exact match and approximate match? How to perform both match type together under 1 index and match function. Are we able to achieve that? I tried before but I couldn't get it as I want to be able to use this formula in any excel version.

[@RJSivakumar]

Excel is really amazing one, which can provide multiple solution for one issue, For complex formulas need to use CTRL + SHIFT + ENTER. To get exact match use 0 as exact match and 1 for approximate match.

[@mrshabeermp]

Thanks

[@coreymanno8946]

What if you had a criteria that was a data validation dropdown element?

[@RJSivakumar]

Creating dependent drop down list is best option for results.

[@farooqtahir538]

So what is the advantage when we have to select every thing from drop down list

[@RJSivakumar]

Remembering all criterias is very difficult, so better to use drop-down for getting multiple results based on requirements.

[@anuraggangawat992]

Not working on date match 😔

[@erictsang789]

What to do , if i want to make the date as "Less than", how to express in the formula?
Thanks

[@RJSivakumar]

Thank you for your query, use < symbol for getting less than date. Every date has value so use that value for example 1 means 1/1/1900.

[@erictsang789]

@@RJSivakumar RJS
Thanks but what i mean in your example
We want to look for price less than4,500 for example
Eric

[@RJSivakumar]

Ok, first start with if conditional formula with price reference

[@B2leave]

I can only assume that this isn't compatible with earlier versions of Excel, because it doesn't work for me at all.

[@RJSivakumar]

Make sure that Press Control + Shift + Enter after entering formula

[@aishahalmulhim1068]

Always comes NA I dont know wats wrong

[@abidsaeed4740]

tried the same function but not working, even on same data

[@RJSivakumar]

Please note that whenever & is used for adding conditions, for old excel versions, need press CTRL + SHIFT +ENTER.

[@arturogallobalma4621]

=INDEX(G2:G15;MATCH(I2&J2K2&L2;INDEX(A2:A15&C2:C15&D2:D15&E2:E15;0);0))
In this case, CTRL+SHIFT+ENTER is no longer used.