Thank you for this

I self taught Vlookup first then index match. I need to use index match more often to stay fresh.

It didn’t work for me. The data in my column contains letters and numbers. I guess I have to continue with my search.

BRO, I wanna give you a big hug.

INDEX is wonky, I like OFFSET MATCH combo...

Thank you🎉🎉🎉❤❤❤😂😂😂

But this seems more complicated that just using Vlookup. You have to do 3 times the work it seems. I agree with @thinkleclt.

Thank you so muchhhh<3 !!! God Bless youuu!!

You got yourself a like, very clear and easy to follow instructions, exactly what i need. Thank you ❤

BROO YOU'RE MY SAVIOR❤❤❤

I've often used OFFSET and MATCH for this purpose. Good to know INDEX will save me a couple characters.

Thank you! You saved me from jumping off a bridge! I just wasted 2 hours trying to figure this out! I have subscribed and will visit your channel again next time before I waste so much of my time and sanity! I owe you BIG TIME!!!

This is huge! Thank you!.... One question - I noticed if my Tabs or Sheets are two words, that it's not calculating. Giving me "#REF!" - Any tweaks to the formula for it?

It was great help, thank you

This totally worked, I have been trying to fix this error for months.

Me spending 3 hours figuring out why it doesn't work this time while it works previously. I need to change careers lmao

Yes index and match does seem like it is better than vlookup, but not nearly as much as you overhyped it and downplayed vlookup. You can use match with vlookup, it is more restrictive but can be done.

why it is not working in me

Thanks!☕

You are so easy to follow and understand. I have watched multiple videos of yours today while working on a big workbook and its going to be the most amazing thing ever. My client just need an old 97-2003 workbook "template" updated and tidied up but its getting a full makeover! I have it all drop down boxes and xlookups, with locked cells. I have been using Excel for over 2 decades but the tricks I found in your playlists today are such time savers it is incredible. Not usually a fan girl but you are the Taylor Swift of excel sheets!

Stumbled onto this video while searching for a different issue in my sheet using VLOOKUP. Will be switching that to XLOOKUP. Thanks for a great tutorial. Now I will go see if I can find a video on my actual question 😂

Amazing. I spend alot time before watching this video but this video resolved my problem.

Best video in youtube ever done, congratulation you were the only one in the world who could accomplished this, not they can fire all the Indian fromt he MS excel department and give to you all their salary.

Thank you thank you ❤❤❤ saved my skin bro

Indexmatch just work in one colum.. with same place on 2nd colum its showing spill! Why

This is great, thank you!

Combining Vlookup and Match will make it dynamic.

Dose Xlookup do the same job? and how?

That is realy Awesome!

it was good but you should put the file over here so that everybody can download and practise of the same. thanks

Thanks for sharing. Really helpful

Thanks for your help but it did not work for me

This worked! Thank you, sir!

Spent 2-3 hours today trying figure this out. Thanks. Done. Subscribed.

Hello, how to fix n/a errors due to symbols like "～"

Very valuable contribution! Many thanks. A quick aside: parentheSIS is the singular, parentheSES is the plural. You can't have a single parenthesee...

Bha ha this is funny. There is nothing simple or easy about Index Match🤣🤣

Thanks If I have many result(quntitys) and I want total it how can do it ?

Thanks

You save my day🎉

How do I get N/A's to sum in a column. Excel is stuck on formulating Vlookup in an array (annoying), and Im stuck not able to sum anything.

2 Days on this and you fixed it thanks!!😄

This issue was irritating me a lot, you fixed this doc

Still does not work for me. im pulling data from a filter function.... can't figure it out any way I try

would this function work if I wanted to assign individual values(word frequency data) to words and then tally up a sentence to see the total on each sentence?

What if the lookup value is a list in a data validation?

Nice

This is so helpful!! Thanks

Fucking lifesaver

Thank you for posting a really helpful video with a quick answer not forcing us to watch 27 minutes of chatter. You are a legend 😊