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

[LGPhibi]

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

[ExcelIsFun]

@LGPhibi , You are weclome!

[jonathan92591]

Thank you.

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

[kajovichi]

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

[ExcelIsFun]

@kajovichi , try:

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

[uzemoz]

Thanks :) for the exemple just i needed

[ExcelIsFun]

@uzemoz , you are welcome!

[DavidSarnowski]

In Excel 2010, I am unable to open the name range selection box from the data validation area. You did it in the video by pressing F3 while in the Source: field of the Data Validation box.

Can you tell me how to do this or have an idea why this is not working?

Great videos! A real help to all.

Dave

[ExcelIsFun]

I do not know. Sorry. Maybe just type the name.

[ajrjsw1]

Hi Its really cool thx a lot, and your explanation is clear as will, once again thx a lot

[ExcelIsFun]

You are welcome!!

[Asusisuful]

Can i choose one item in a down-down list and shows 4 results in 4 cells?

is that possible to make it?

[ExcelIsFun]

Yes, combine the things you see in this video with VLOOKUP and COLUMNS from this video:

Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH

[rsoreo]

Can you make 2 drop downs in one cell?

I need to make something like this;

1personx12hoursx30days.

So I need 3 drop downs.

Many thanks in advance

[ExcelIsFun]

I do not know how to make 2 drop downs in one cell. Try THE best Excel question site:

mrexcel[dot]com/forum

[CFreehill]

These videos are very useful. Thank you.

Regarding the ability to refer to named arrays defined other worksheets in the List Data Validation dialog, is this capability available in 2007? When I try to do this, I get an error. Thus, I'm wondering if the capability is available only in the latest versions?

[ExcelIsFun]

I get an error too, but that does not mean that it is not possible. Try posting to THE best Excel question site:

mrexcel[dot]com/forum

[CFreehill]

@ExcelIsFun

Will do....thanks.

[Lithobilic]

Amazing saved my ass when I didn't know what to do for my course work; keep up the good work!

[ExcelIsFun]

I am glad to help!!

[MsNJohnson]

Good stuff, Dude!!

[ExcelIsFun]

I am glad that you like it!

[KbobGaming]

Thank you very much. I'm building my own Warhammer Army Builder (saving myself $40...) and this is perfect for creating squads and then making lists of their replacement gear and linking to the respective points value. Life saver, for sure!

[ExcelIsFun]

You are welcome!

[compuclickcouk]

never commented on a video before but i must say this helped me loads! thank you very much

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

You are welcome!

[walhaidary]

HEY, THANKS FOR THE VIDEO, I TRIED THE DATA VALIDATION WITH THE VLOOKUP FUNCTION TO DO THE PRODUCT PRICE TRICK AND IT WORKED JUST FINE, THE ONLY PROBLEM I HAVE IS WHEN I MAKE A LIST OF PRODUCTS IT DOESN'T MATCH THE CORRECT PRICES UNLESS THE PRODUCT ARE LISTED ALPHABITICLY :(((

IS THERE ANY WAY I CAN GET IT WORK WITHOUT SORTING THE PRODUCT ALPHABITICLY OR MAYBE THERE IS SOMETHING I'VE MISSED???

PLZ HELP!!

[walhaidary]

@walhaidary by the way, I did wrote "false" segment at the end of the formula but it doesn't work iether :(((

[ExcelIsFun]

Yes, put a 0 (zero) in 4th argument of VLOOKUP.

[aman1245singh]

Thanks for the videos again. :)

[ExcelIsFun]

You are welcome!