Hello,
I am setting up a database template for people who are not Excel trained and
I am attempting to make the input easy for the users as well as myself when I
begin analyzing the data. I am trying to an if-then statement or create a
macro (I know nothing about macros) that will allow me to have the users
select their county for a list validation and the county number appear the
cell to the right of the county name.
like this

County County Number
Excel 67856

Any advice would be helpful.