if statements

[Guest]

I want to create a form that has a drop-down box to chose a persons name.
Depending on which name is chosen, I would like the sheet to fill in a
contact name. Example: If they chose Joe Blow as the Producer, the contact
would be Sally.
But if they chose Jim Jones, the contact would be Kelly. What is the
easiest way to do this?

 

[Guest]

Look at VLOOKUP; create table of person to contact e.g column A has person,
Column B has contact.

=vlookup(person,contacts,2,false)

where <person> is cell with name
<contacts> is two column table (as above)
2 selects item in second column (B) of <Contacts>

HTH