Help in drop down list/menu

[khassim]

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?

Thanks in advance.

 

[pedie]

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]

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]

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.