Was trying to use the IF function and it works but do not know how to add multiple IF in a row.

Example:

Sales People are:

Eric Christian
Kevin Hulcy
Michael Christian
Scott Kornberg

Whom ever enters in their name into the cover worksheet cell, I want another cell on an invoice worksheet to pull the correct data, pertaining to that sales person.

If Eric Christian is the sales person =IF(A1="Eric Christian",Z1) Cell Z1 would have all the contact information required for Eric Christian. How do I use the same function but add all the other sales people?

Tried this but did not work:

=IF(A1="Eric Christian",Z1)IF(A1=Kevin Hulcy,Z2)IF(A1="Michael Christian",Z3)IF(A!="Scott Kornberg",Z4)

Ideas? Solutions?

Thanks,

Eric