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.
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.
Nice, no BS, straight to the point. 1000 thumbs up.
Thank you
You just saved me over 8 hours of manual work lol. Thanks!
Thank you so much! I didn’t know you could do the “ &”combination for multiple criteria a much better shortcut!!
You saved our lives, sirr! Thankss❤
Your explanation was so simple. Thank you.
Thank you 🙏… god bless you
Excellent
Thank you so much,this is really helpful :)🙏
really helpful! thank you
You're welcome!
Excellent !!!
Thank you! Cheers!
thank you, short clip!
Many thanks!!
thank you very much! 🏆🥇
Not working on date match 😔
Nice video
Thank you very much
Thnaks my issue is resolved
Thanks for watching video👍
Its awesome, same thing can you explain for an example include date instead of code.
Yes, sure. Lets hope another video.
Thank you so much for this.
It’s perfectly working but showing error in some cells. Could you please help me with that.
And function gives result only when it meet all conditions. If any condition is not met with then it will not show result.
What if you had a criteria that was a data validation dropdown element?
Creating dependent drop down list is best option for results.
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.
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.
Thanks
Excellent
Thank you for support
So what is the advantage when we have to select every thing from drop down list
Remembering all criterias is very difficult, so better to use drop-down for getting multiple results based on requirements.
Thanks....
What to do , if i want to make the date as "Less than", how to express in the formula?
Thanks
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.
@@RJSivakumar RJS
Thanks but what i mean in your example
We want to look for price less than4,500 for example
Eric
Ok, first start with if conditional formula with price reference
tried the same function but not working, even on same data
Please note that whenever & is used for adding conditions, for old excel versions, need press CTRL + SHIFT +ENTER.
=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.
I can only assume that this isn't compatible with earlier versions of Excel, because it doesn't work for me at all.
Make sure that Press Control + Shift + Enter after entering formula
Always comes NA I dont know wats wrong