Index Match with Multiple Criteria

This video explains how to perform a lookup for a value based on multiple criteria. A normal vlookup or index match will not work since you only provide one criteria for these types of lookups. Instead, we have to use an array. Below is the link to the file that I use in this video:
readyxl.teacha...
#msexcel #excel

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

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

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

[@billknauss7963]

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

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

[@VP-yp8ip]

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

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

[@hpham9]

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

[@kenghockong4462]

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

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

[@exceltech6012]

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

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

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

[@cy3653]

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

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

[@rahulsaini2190]

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

[@NetherVoiD]

You sir is a Life Saver

[@astmrana]

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

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

[@zaidamir3002]

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

[@sidneydanielgomezbriceno7715]

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

[@yanduarte2858]

jes man - what a simple but great explanation

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

[@andreasanzetenea6738]

The best so far!

[@critical_analysis]

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

[@RajuKutala]

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

[@majorkiki8340]

THANK YOU! Clear and to the point!

[@rinturay1572]

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

[@dkmathur100]

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

[@jayk2588]

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

[@rasheefdecarter8757]

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

[@askpkt6304]

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

[@chethantr4720]

Thank you so much much useful information 🙂

[@nadeeraperera3620]

Thank you, mate. From Sri lanka.

[@timilehinfabanwo6097]

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

[@itravelholidays8375]

thank you so much, this really help me great job

[@nickdelrio9255]

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

[@patrickmathias2591]

Thanks sir. Feel I LEARNT something good 🎉

[@solutionwithenjoy6601]

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

[@fazudli]

you saved my day.. thanks

[@askpkt6304]

Very easily understandable Very Good ,

[@hatrang4917]

great video, helped me a lot

[@mattvatcher]

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

[@rohscx]

Thanks. Worked well for me.

[@AlexisRiveraGuitarra]

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

[@dharmalingeswarparasa1609]

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

[@nicolaconte3887]

Thank you! Very useful!

[@shreekrishnasitaula2739]

much appreciated. Helpful

[@sanjaygoyal5486]

thanks for the video! it helped me a lot

[@VaibhavDhale-j4j]

very helpful video thanks

[@vishwanathvishwa9219]

Thank you :) it was of great help

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

[@tommyharris5817]

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

[@nursyahirahabrahman9037]

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

[@ndbvlogs5501]

thank you !

[@aloha3577]

Thank you for the good one.

[@LordEskay]

Thank you so much❤

[@RamonLVillalona]

This is awesome!

[@erwerwewerwer4575]

Brilliant! new subscriber

[@promodigitalbd]

Very nice video

[@claudiohernandez8665]

Simple! Thank you!

[@Sharfinful]

Thanks a million

[@chiragjain9545]

Thank you so much

[@doshannringo]

Thank you!

[@Narindersingh-ns7uv]

THANK YOU SOO MUCH

[@vedsoni2040]

thank u so much buddy

[@gopalane9001]

Thanks brother

[@SpreadHappinessonly]

Thanks a lot

[@jonathanpangu3717]

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

[@MohamedMostafa-jh6rc]

exceed amazing one

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

[@willbadel7566]

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

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

[@laukittom9789]

Best video

[@kavitanaik2198]

Does index and match work on column instead of row

[@edemvillanueva8117]

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

[@stonercfc]

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

[@sumanuhiremathsuma9229]

Ann idea how we can implement this in VBA macro

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

[@H3lom]

Brilliant

[@sajomathew3213]

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

[@Ty33Budd]

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

[@jewelserniabad9211]

Thanks

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

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

[@shahidjawaid6137]

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

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

[@karthikkayan8049]

Plz explain Ctrl+shift +enter

[@rakeshpandey7800]

Superh

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

[@md.ashikurrahman1767]

nice

[@sandyclairesurla]

hoping that you can still upload excel hacks :)