IF function Problem

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

Try this:

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

There are other (better) ways of doing it with other functions, but this shows one way of joining those multiple IFs together.

Hope this helps.

Pete

We would need to know more about how your data is set up. Try to supply a small sample file (with no personal data) that clearly shows your setup and a few examples of what you want to achieve.

Am I the only one who thinks there is actually more than 4 sales people????

Well, the post as been marked as Solved, so presumably the OP has got what s/he wanted.

Pete