• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Customized Data Validation List

VolOdd

New Member
Hello Chandoo, I hope you can help.


Hi Chandoo,


Maybe you could help me.


I need to do a customized Data Validation list. The parameters:


The field to pull the list from looks like "12345 -- Role Name -- Role City"


I want to see the whole string in the list picker, but only want to see the first numbers once selected. The numbers can vary in length, the "--" will always exist.


Or, the above field is a combo of three fields, I'd still like to see all three fields in the drop-down, but only have the first number populate.
 
Hi VolOdd,


Welcome to the Forums!


What i have understood is that you have data that looks like "12345 -- Role Name -- Role City", present in only one column and that you want to have a combo box that shows you only "12345" part of the data? Is that correct?


So once you select 12345, the rest of the part should be selected defect o? Is it correct?


Regards,

Faseeh
 
Good day VolOdd


I think the way to do this would be with dependant data validation...but this would give you a two column list.
 
Faseeh,


Not quite, in the picker, I want it to show "12345 -- Role Name -- Role City", however, once picked, the cell would only have "12345" in it.... I need that number to then do lookup's in another table.


"12345 -- Role Name -- Role City" is a combined field. I have 3 of fields "12345", "Role Name" and "Role City" that I've merged together with =[@[Req#]]&" -- "&[@[RoleName]]&" -- "&[@RoleCity]


I only need the Req# on another sheet, but the users what to see RoleName and RoleCity in the drop down as well to help them choose.
 
Hi VolOdd,


Please see this, In cell C2. Is it that you want:


https://dl.dropboxusercontent.com/u/60644346/Combo%20%26%20Data%20Validation.xlsx


Regards,
 
Faseeh, thanks for responding... I actually found something that works in my situation: https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/data-validation/replace-choice
 
Back
Top