hello all, excel list?

[Sundeep]

Hi everyone, I have a quick question regarding excel lists.


I want to create an excel drop down list where I select a certain title
from the list. It then puts out 2-3 lines of information onto the main
worksheet

So in the list i chose

Joe Smith

it would then put out on the top of the spreadsheet or anywhere on the
spreadsheet..

"Joe Smith, Phonenumber, currently works in this department, currently
drives this car.


If someone could help me on this, it would be greatly appreciated.

Links or anything would be awesome.

Thanks!

 

[SteveG]

Sundeep,

You could use in B1,

=VLOOKUP(A1,$E$10:$H$18,COLUMN(B2),FALSE)

Where your drop down is in A1, E10:H18 is your data with names in
E10:E18(Joe Smith, Phone number, currently works in this department,
currently drives his car). Copy this formula across to D1.

HTH

Steve

 

[SteveG]

Sundeep,

Slight change,

=VLOOKUP($A$1,$E$10:$H$18,COLUMN(B1),FALSE)

Make the reference to A1 absolute ($A$1) so when you copy across i
doesn't change.

HTH

Stev

 

[Sundeep]

Great, it works perfectly. But now one more problem though, the dro
down list always keeps showing the data in it, for ex

Drop Down Title
name
name
name
name
name
name
name


How do I hide the names so that all you see is the title and when yo
click in it you select a name from the list without a huge list poppin
up underneath the drop down title box

 

[Pete_UK]

If you have a long list of names, it might be easier to use dependant
data validation, whereby your first list could be "Names A-D", "Names
E-J", "Names K-P" etc, and then depending on which of those are chosen
your second list gives only the names in the first category. This link
gives some detailed examples:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

 

[SteveG]

I would check out Pete's suggestion. You could categorize your list
that way and make them smaller. Regardless, when you select the dro
down, it will show your entire list for the category.

HTH

Stev

 

[Sundeep]

Thanks guys, really appreciate the help. I just finished it and i
looks awesome!



I love this forum

 

[SteveG]

You're welcome. Thanks for the feedback.

Regards,

Steve