Combobox

[dweekley]

I am trying to create a combobox based on values on another sheet. This I have been able to do, however, I am getting what I think is the index value in the linked cell. I am wondering if in the drop down, I see the company name, but in the linked field the entire Name, addr, City, State, Zip is populated. On the Company name sheet I created a cell and formula to concatenate and line feed the other cells no problem.



I hope I explained this correctly.

Also, which type of combobox should I be looking at. Validation, Form, ActiveX?

TIA

[xor]

Can you upload the file?

[dweekley]

File is attached. I ended up using validation for the time being, but you can see how it is displaying the entire cell contents.

[NBVC]

Have a look here:

https://superuser.com/questions/9235...ction-in-excel