Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

See how to:
1)Add drop down by typing values in
2)Add drop down by selecting range on worksheet
3)Add drop down by naming range on different worksheet
4)Add a warning message
5)Check to see if data is valid
6)VLOOKUP function
7)Name a range
8)Check the list of Names
Add Data Validation Drop-Down List To Cell List on Worksheet or Different Worksheet

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2010
• Add
• Data
• Validation
• Drop-Down
• List
• To
• Cell
• on
• Worksheet
• or
• Different
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[LGPhibi]

Thanks so much....i am learning a lot from your videos...

[ExcelIsFun]

@LGPhibi , You are weclome!

[sdmayer123]

You're videos are amazing!!! I have a question regarding validation lists, to expand a bit on this particular one. Is there a way to, using a validation list in a single cell, select multiple values from that list and have each selected value appear in that single cell separated by commas? Thanks in advance!!

[ExcelIsFun]

@sdmayer123 , I do not know. Try:

mrexcel [dot] com/forum

[spanishCkent702]

okay, I've been looking everywhere for this but i can't seem to find it, and I've found your videos to be the most useful. How can I add multiple drop down lists onto one cell. Like when creating a weekly schedule and having time employee comes in, and time employee clocks off. I'd like to have both of that data on one cell.

[ExcelIsFun]

I don't know, try:

mrexcel [dot] com/forum

THE best Excel question site.

[jonathan92591]

Thank you.

[ExcelIsFun]

@kajovichi , try:

Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables

[kajovichi]

How can you select a table array that consits of two coloms that are not directly next to each other?