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

"Julie" wrote:

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?