Conditional Drop Down Lists Based on Lookup

[tarc53]

Hi All,

I currently have a list of companies and their corresponding company ticker symbol. I want to be able to choose either the ticker symbol or the company name from a drop down and have a corresponding cell populate information. For example if I select "GE" from a drop down list I want the column titled "Company Name" to populate with "General Electric," but I also want the ability to select "General Electric" from a separate drop down and the Ticker column to be populated.

 

[etaf]

you could do that using a lookup

index match may be better to use

so setup your drop down list from data validation

then assumig
drop down for Ticker in A1 and you want name in B1
drop down for Name in C1 and ticker in D1

and the table say in sheet2 A1 to B1000 - for the A1 = company and B1 = ticker

in B1 sheet1 put
index(Sheet2!A1:A1000, match(A1,B1:B1000,0))

in D1 sheet1 put
index(Sheet2!B1:B1000, match(C1,A1:A1000,0))

 

[tarc53]

Wayne,

Thanks for the response. I was hoping to keep the drop down lists contained to two columns. I think this is going to require some VBA.

 

[etaf]

i have only suggested two columns
but yes, VBA may give further flexibility,

also there are a vast number of companies - so the dropdown will be very big