was able to use the Data Validation. However, my problem now is for the
address field. I have it so I have a chose a customer name. That pops up
their address, which I have in this format, 3345 Clearview Avenue, Anywhere
City, OH, all on one line. I need 4 lines. I am going to change the
customer name to a code I have to use, that needs to pop up the customer name
and the address. However, I need the format to look like this:

W2234
John Doe
3345 Clearview Avenue
Anywhere City, OH 79990

The current format is:

John Doe
3345 Clearview Avenue.Anywhere City, OH, 79990

Is this possible using the validation. I was looking at the Dynamic option
but little confused and not sure this will do what I want

Thanks for any help