yo thanks man!

This is amazing! Can you create one similar, with 3 dependent drop-down lists for dates, and share or tag me? Cell A1: Year (YYYY) Cell B1: Month (MMMM) Cell C1: Date ([DDD] DD/MMM/YYYY)

the error created make the drop down not work...at least for me

This did not work for me. It shows the 'This Table is empty'

Thank you so very much. Great video and very helpful for what I needed. 🙏

what if I want to get the department having my lookup value as contact. Thats basically the value that I am looking for is in the last row of the table instead of first. How can I get that answer?

Very useful video. Well explained and broken down.

OMG. this was the easiest video I've watched

Any idea how to do it without the `indirect`?

Worked for me, tnx!!!

😇 NOT WORKING IN "Office 21"

Can you help me figure out how to automate the formula to apply for all the rows?

Great instructional video; I appreciate your approach to teaching.

This was super helpful thank you

can excel 2019 do this?

u saved me big time .. was in my restored one drive but not in my local roaming folder . thank you!!!

What if for example, you want only rows 5 and 6 frozen? Is that possible?

Thanks

This was so helpful. Mine keeps pulling wrong numbers from the list.

Thanks for simple and useful video made my life easier

thanks very usefull. i make EDM music

It’s now working for mine😭. If I find a column that has blank and I start checking each column to deselect all and leave only blank, I end up not finding any blank and I can’t click ok. Please what can I do?

Very very gooooooode

Thank you sooo much for making it so easy.. God bless

థాంక్స్ రా బాబాయ్.. బాగా explain చేశావ్ ! (THANKS BRO... GREAT EXPLANATION. )

very helpful thank you

Amazing

Although you have helped me tremendously explaning this, would it be possible for me to ask a question relating to the use of INDEX/MATCH please

Great explanation, thank you without an irritating voice.

That was awesome! Thank you.... quick and simple.

Great info. The name split is a time saver.

Thank you so much for making this video! You just don't know how much you've helped me with a project I'm working on 🙂

great

Amazing Tutorial. Thank you!

Thank you. The one that actually works

Super clear and very nicely explained, thank you very much

Excellent 👌 I really needed this.

Thank you

Mine is the freeze pane so far helped me a lot

I’m in sunny Florida

Yes very clear

Hi

Omg thank you so much I was having such a hard time til I saw your video. ❤

0:45 Thanks man!

EVERYWHERE I search I find more and more complicated and time consuming ways to simply put a check mark in a document. It's very frustrating.

Thanks!

Thank you, thank you!!

What about creating more than one criteria? I need to pull data based on 3 columns of data

Thank you for saving my life, genius!!!

Thank you!