software

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?

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 lt;persongt; is cell with name
lt;contactsgt; is two column table (as above)
2 selects item in second column (B) of lt;Contactsgt;

HTH

quot;Juliequot; wrote:

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