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

Can you upload the file?

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

Attached Files

F 12.0-2 - FAI - AS9102 - Testing.xlsx (36.9 KB, 10 views)

Have a look here:

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