Select Short or Long Drop Down List in Excel

[DJTamasH]

Thanks for this video it was very very usefull BUT I'd like to see some more information for the customer I have alredy choosen from the list on the same sheet.(like address,phone number etc)

Any link to show me this extra thing?

Cheers!!

[contextures]

@DJTamasH Thanks, and you can use a VLOOKUP formula in another cell, to show related information for the selected customer.

I can't add a link in this comment, but search in YouTube for Contextures VLOOKUP, then click on the video for "Find Product Price in Excel with VLOOKUP "

[ParSev21]

This is great! How do you do this for an entire column other than dragging the first cell down through the whole column?

[contextures]

@ParSev21 Instead of selecting just one cell (e.g. cell E3), select all the cells where you want the drop down lists, before you add the data validation.

Then, in the data validation formula, use a relative reference to the active cell, instead of an absolute reference.

For example, if the active cell is E2, refer to it as E2, instead of $E$2:

=IF(E2="Full List",FullList,ShortList)

[73davie]

really clever trick....thanks for sharing

[krn14242]

This is a great trick, thanks.

[aad11]

GREAT!!! :))

[dwheavyd]

Great idea! I hate scrolling through long lists, when 5 or 6 items are all I need 95% of the time. Thanks!