MS Excel - Data Validation

What if the drop down list country option is present in another sheet,how would we fetch it, and how can this drop down list be done through vlookup function

Thank you so much sir 🙏🙏

Thank you sir 👍

Very well explained!!no waste of time with intro & outro 👍

Nice content. Tutorials are much understandable without much time wasting

Do you have any video on Vlookup with multiple criteria to match?

You are Awesome!

I like your way of teaching. You explain the topic very easily...👍👍👏

How to i need to alter the table bcz I have to add more cities

Good Teaching Method Sir. Very Simple Way Of Teaching. No need to watch again.
Thank You Very Much sir

Thank you

Can you zoom your screen i m not able to see the exact

You are perfect mate..

Really appreciated, very very detailed explanation...Thank you dear.

thankyou, the lesson was very productive

Thank u sir

Usefull ❤️

Tank you so match, you really help me with yours videos 😊

I so much interested in your tutorial it well explanation, kudos to you...!

Very easy and effective way of explanation. Thank you.

So far today i came to know that Excel is male 😅😅 because master always used to train him ..... Jokes apart excellent teaching master 😊😊😊🙏🙏

Very nice video. Very informative. No time waste. Thank u.

THANK YOU !!!

Simplest illustrations and easily learned concept, thank you so much sir. May be one more request, how do I create another name range for a second segment assuming I need to create dependent dropdown lists for 3 columns, 2 of which must depend on the content of the first column

Great!

You looking like dhruv rathi

This sir is best than many other sir's to whom we pay for getting certificate online

Excellent presentation. Concise and to the point and no unnecessary music or background noise.

👍

when i copy one cell value to another cell, Data Validation rules getting overridden. how to avoid data validation from being overridden? i cant restrict copy & paste as excel has huge no. of records

when copy paste data from other cell in date , date format not validating. Please suggest

Amazing

Nice presentation

How to remove duplicates from drop down list?

Excellent tutorial , learning from KENYA Africa

So good and simple explanation

sir plz help and slove , =now() current time in cell and manualy time another cell both are similar how to define vlookup , validation , true /false etc

In 10 mins i understood better than going to class. very useful videos !

Your explanation is amazing sir

need u r help..

small req...

need to change my status if planned date is older than today..

how to do in excel

Superbbbb sir....

Thanks a lot sir

superb ...very well explained..

You are Boss 👍😊

spprb and very helpful ur information tqqqq

Superb sir, salute to you🙏🙏

Wow sir gatay yoe