Populate a field based on dropdown choice

Hi Linda Souza,

I literally wrote the book on that.

I hope this helps!

Hi Linda Souza,

I literally wrote the book on that.

I hope this helps!

Thank you Patrick... I saw that post and tried to make it work.  I don't think I explained myself...

I have a dropdown with List with Company.  When User chooses the Company from the dropdown, I need a field to populate with the Company Address that is stored in another DropDown "Company_Address"

So, if User chooses "Linda Company" from Company DropDown, then I need the associated Address to populate the field "Company Address"

I don't know the formula, but Address = 

Case when Company "Linda", then  "1 Main Street, City, State", when Company "Bob" then "2 Elm Street, City, State"