Index match with multiple criteria | excel multiple columns match

Подписаться 1,4 тыс.

Просмотров 41 тыс.

50% 1

💻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
+91 9019345698
Donations are much appreciated.
UPI/Bhim Number
+91 9019345698
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

Опубликовано:

28 окт 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 43

@Fxingenieria 6 дней назад

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 10 дней назад

Thanks....

@sudmudmud357 6 месяцев назад

Thank you 🙏… god bless you

@bluexwisteria8037 4 месяца назад

You saved our lives, sirr! Thankss❤

@rajeshshah6758 2 года назад

Your explanation was so simple. Thank you.

@adsjectivemedia9200 Год назад

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

@kynesilagan2676 Год назад

thank you, short clip!

@agape13 2 года назад

thank you very much! 🏆🥇

@Serfos1 2 года назад

Many thanks!!

@divyalakshman2109 Год назад

really helpful! thank you

@RJSivakumar Год назад

You're welcome!

@anuraggangawat992 2 месяца назад

Not working on date match 😔

@ravirajwal5593 Год назад

Thnaks my issue is resolved

@RJSivakumar Год назад

Thanks for watching video👍

@maduraiquickcooking3824 3 года назад

Excellent

@RJSivakumar 3 года назад

Thank you for support

@br31woodlands69 2 месяца назад

Nice video

@RJSivakumar 2 месяца назад

Thank you very much

@rahulvinod3441 2 года назад

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

@RJSivakumar 2 года назад

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

@wasimakram11 2 года назад

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

@RJSivakumar 2 года назад

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 11 месяцев назад

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.