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