Index Match with Multiple Criteria

[@zamora0417]

Coming from a corporate professional that handles lots of data, this is probably one of the most valuable excel tips I've ever learned and continue to apply. Very much appreciated!

[@tormentedbuilder1355]

I've tried different index match methods from other videos to solve my problem trying to match records containing a username with multiple dates with another sheet's corresponding values attached. This is the most effective in that specific problem - thank you

[@hhinsurance5089]

How? ive been trying to get this to work with dates with no success

[@launabilal648]

YOU ARE A GENIUS. THANK YOU! that concatenate shortcut was incredible.

[@mdcs1992]

I've looked at 4 other videos trying to understand this. Yours is the one that helped. Thank you very much.

[@Always_ponder]

easily the best explained video on this topic. I’ve watched numerous videos on this but none came close to simplifying it as this one does - superb and thanks very much

[@ydp.studio]

This is excellently helpful!! Most of vlookup tutorials are failing to give what it means with "multiple criteria". Most of them use two criteria I even can apply this with google sheets

[@billknauss7963]

The best video I've see yet on this subject. Very clear and understandable.

[@kenghockong4462]

your control shift enter actually help me a ton. thanks alot bro.

[@VP-yp8ip]

I really appreciate this. That helped me so much by avoiding enter data manually.

[@hpham9]

You ARE MY HERO!!! Thank you for introducing the Array feature!

[@tokabadreldenmosaeed2768]

I really want to thank you for this easy function. the course I am taking and lot of other videos are using other complicated functions and they explain them with a really complicated way. but u make it a peace of cake. grateful for u, and keep going.

[@angelacheung6834]

I was almost giving up on learning about index match function and stumbled upon this video! Thank you so much :)

[@matthewdefee171]

Really good video! This is the 5th or 6th video I've watched on this function and (embarrassingly?) this is the first one that explains the process in a clear and relatable manner. Not to mention that you took the time to explain an even simpler alternative - nice touch. I appreciate your time and effort 🍻

[@exceltech6012]

I have already watched so many videos but this is very different approach . Really very nice thank u

[@rahulsaini2190]

You have solved my problem after 5 years😢😢😅 thankyou

[@christyb6466]

Thank you for this!!! I have been to multiple websites and watched a handful of videos. NO ONE explained it this well. You deserve far more likes than this video received. Thank you again =)

[@reubenlarmie5013]

Very True!

[@jesseparsons1508]

Wow, totally awesome!! Been trying to figure out how to compare 2 columns of differnet city locations for calculating delivery charges. Was trying to do it with if,and functions but was getting confusing. This is the way to go!! Thanks

[@readyxl8768]

Glad it was helpful!

[@cy3653]

OMG! AFTER SO MANY VIDEOS .. FINALLY ONE THAT HELPS ME!!!!

[@NetherVoiD]

You sir is a Life Saver

[@RA-rh5lb]

My learning of Index match for the multiple criteria which I learned only because of your video and I am humbly obliged to you..

[@RA-rh5lb]

Wow I have been trying my best to learn from the different videos and this one is best i have come across for the Index match for multiple criteria . Thank you very much. Mostly i will memorize this tips because couldnt understand the basic logic on why did you use concatenate..

[@Sirhl]

Amazing, I've always used these functions, but I never understood the underlying reasoning for the function. Thank you for the clear and concise clarification!

[@krithish1]

Thank you so much. I am really glad I found this video after spending a long time and this really helped solve one of my requirements in excel. Appreciate your time and explaining this with amazing clarity.

[@sidneydanielgomezbriceno7715]

Thank You Mate! Very useful, concise, easy to understand & Thorough! CHEERS!

[@yanduarte2858]

jes man - what a simple but great explanation

[@astmrana]

Amazing! I learned this first time . Very Much Appreciated!

[@zaidamir3002]

Thank you for sharing this multiple criteria trick, it solves my problem, Great Thanks a lot. Bravo

[@memenadekhanh3992]

Not all heroes wear capes. You are certainly one.

[@deniseagotilla100]

Thank you so much! This helped me out greatly and you explained it so plainly that I got at the first go! (a few rewinds here and there teehee) thank you again so much!

[@RajuKutala]

Nice. Have been looking for this since a while. Thanks a lot

[@rinturay1572]

Thanks, bro I got to learn a lot as a beginner

[@majorkiki8340]

THANK YOU! Clear and to the point!

[@critical_analysis]

Amazing video, thanks for this tip. I used this tip to solve one issue I was facing. Thank you.

[@jayk2588]

Thank you so much, I got my issue resolved with this video. Thnaks a lot !!!

[@dkmathur100]

Bro thanks so much, made my work alot easier 🙏🙏🙏

[@rasheefdecarter8757]

Great video. Was helpful at a critical time. ❤️❤️❤️

[@askpkt6304]

Very useful for what I serched for , many thanks for your video sharing

[@patrickmathias2591]

Thanks sir. Feel I LEARNT something good 🎉

[@chethantr4720]

Thank you so much much useful information 🙂

[@nadeeraperera3620]

Thank you, mate. From Sri lanka.

[@mattvatcher]

Legend man! Thank you so much! Brilliant on the concat.

[@andreasanzetenea6738]

The best so far!

[@AlexisRiveraGuitarra]

Thank you so much! This is exactly what I was looking for!

[@timilehinfabanwo6097]

Love you so much for this!!! Just saved me hours of headache. Keep it up 👍🏾

[@hatrang4917]

great video, helped me a lot

[@itravelholidays8375]

thank you so much, this really help me great job

[@solutionwithenjoy6601]

thank u man, u have solved my problem love u bro

[@askpkt6304]

Very easily understandable Very Good ,

[@nickdelrio9255]

Thank you very much! This helped me a lot. I'm now a subscriber! 💜💜💜

[@tommyharris5817]

Very good; didn't know you could do this.

[@sanjaygoyal5486]

thanks for the video! it helped me a lot

[@vishwanathvishwa9219]

Thank you :) it was of great help

[@dharmalingeswarparasa1609]

Incredible, thankyou very much, it helped me a lot.

[@rohscx]

Thanks. Worked well for me.

[@fazudli]

you saved my day.. thanks

[@khairulamri2609]

I feel like I already follow every step in your video, but the result is #VALUE!. Still figuring things out, thank you for the video though.

[@willbadel7566]

Hey Ready, thanks for the video. Is there a way to achieve this result WITHOUT using an ctrl+shift-enter? Regards Will

[@nicolaconte3887]

Thank you! Very useful!

[@nursyahirahabrahman9037]

10Q bro... it's help me a lot

[@shreekrishnasitaula2739]

much appreciated. Helpful

[@erwerwewerwer4575]

Brilliant! new subscriber

[@VaibhavDhale-j4j]

very helpful video thanks

[@edemvillanueva8117]

thank you! but what if you want to get data from other spreadsheet?

[@aloha3577]

Thank you for the good one.

[@claudiohernandez8665]

Simple! Thank you!

[@sumanuhiremathsuma9229]

Ann idea how we can implement this in VBA macro

[@erictsang789]

I wonder if the "less than "match can apply in this CSE in the case.

[@taryn4080]

Will the array index Match work in Google sheets and conditional formatting

[@diogoportela180]

That’s really good tutorial. I have a question though. Imagine in your example if Apple did iPhone 9 in all diferente Storages from 8 till 64 (8,9,10,11,12,13, etc). But the range of storage from 8-15 is the same price, 16-31 and 32-64 too. How would you find the value of a iPhone 9, 30GB without adding one row for each storage level?! In other words, if I have to combine 3 variables but one of them is a range of possibilities, how would you lookup the value?!

[@LordEskay]

Thank you so much❤

[@RamonLVillalona]

This is awesome!

[@felicia6044]

thanks!! what if there is a storage location column, and we have to summarize all available quantities from specific locations?

[@felicia6044]

I'm trying this, however only get the first row only. would be cool if can explain how to include it with sum too :)

[@readyxl8768]

Hi Felicia-- I believe you are interested in learning how to use the SUMIF function. I go in depth on the SUMIF function in my "Beginner to Advanced in 4 Hours" Excel course which is linked in this video description.

[@jonathanpangu3717]

Is it possible to achieve the same result with a table instead a set of data?

[@shahidjawaid6137]

What if lookup value in 2 cell and lookup array in 4 columns, how do will apply formula ?

[@ndbvlogs5501]

thank you !

[@promodigitalbd]

Very nice video

[@zaidamir3002]

I need to solve this issue, example: if "I-Phone 9 16GB" is again available in ROW with different Qty/Cost, so how can I get the Qty/Cost of both "I-phone 9 16GB" ? pls help

[@stonercfc]

How do I get this to work if there are multiple values to return in a drop-down?

[@Ty33Budd]

This does work, but what if you want this style of function in a Table??

[@Sharfinful]

Thanks a million

[@kavitanaik2198]

Does index and match work on column instead of row

[@vedsoni2040]

thank u so much buddy

[@Narindersingh-ns7uv]

THANK YOU SOO MUCH

[@MohamedMostafa-jh6rc]

exceed amazing one

[@chiragjain9545]

Thank you so much

[@doshannringo]

Thank you!

[@yonasmisganaw6023]

why i can not download this videos ?

[@jasminq2995]

What if the three criteria have more than one returned result? It could only show one of them?

[@readyxl8768]

When that's the case, it returns the result from the first row that meets the criteria.

[@sajomathew3213]

What if you don't have an exact match, how can we manage then?

[@emank930]

Does this formula work in Google Sheets?

[@readyxl8768]

I don't think the array functionality will work on Google Sheets. But the method where you concatenate the string should work on Google Sheets

[@emank930]

Yep, you're right. Concatenate worked but didn't array the column unfortunately. :-( Would you be able to suggest a substitute for an index match with multiple conditions with the array functionality for Gsheets - (Doesn't need to be index match as long as it performs the function of finding a value from another tab based on multiple conditions).

[@tnpanda27]

Thank you sir

[@gopalane9001]

Thanks brother

[@SpreadHappinessonly]

Thanks a lot

[@sandyclairesurla]

hoping that you can still upload excel hacks :)

[@shreehanumanthtrading8769]

Hey Nice video, but the link you shared in description is not working, can you pls verify this once again, Thanks a lot in advance.

[@laukittom9789]

Best video

[@theguynexttoyou]

Was looking for something without concat

[@H3lom]

Brilliant

[@jewelserniabad9211]

Thanks

[@karthikkayan8049]

Plz explain Ctrl+shift +enter