Help in drop down list/menu

khassim

New Member
Joined
Aug 14, 2010
Messages
8
Hi everyone! Am just new here and I have a little problem using drop down list. I have an excel sheet composed of over 6,000 rows and 29 columns. In the row A are entries of winery names row B are address and so on... I would like to know if there's any way to create a drop down list wherein if I choose a particular winery in row A the rest of the description of that winery will follow. Am i making any sense? :confused:

Thanks in advance.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
If you're using excel 2007 then new auto filter will be perfect solution for you. Or else you may also sort it..etc
I am not vey sure what u are up to but seems really easy.
Or u can also use Vlookup formula for this in same sheet or maybe in other sheets or workbook to look that up!

Welcome to the forum:)
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,728
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Khassim
There are many tutorials regarding VLOOKUP.
Here's one for starters
spreadsheets.about.com/.../excel-vlookup-step-by-step-tutorial.htm
but you can Google "VLOOKUP Tutorial" for thousands of others.
 

khassim

New Member
Joined
Aug 14, 2010
Messages
8
Thanks a lot guys. I was trying to use filter and was wondering why it wasn't working. I forgot to remove the "format table styles". Thanks again.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,606
Messages
5,597,134
Members
414,128
Latest member
Jorglo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top