• 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


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

Data Validation List


New Member
I have assigned codes to some items such as

01 Item A

02 Item B

This information is in different columns.

I have combined this information and assigned it as a list for data validation for a cell. What I want is after I select an entry in the data validation list, I only want the item name and not the item code populated in the cell

e.g. I will select '01 Item A' in the dropdown and what gets populated is 'Item A'.

Can this be done without using VBA?

There is a very good article on what can be done with validation and VBA at