Multiple Sheet Help
 

I need a little excel help he

I'm trying to tie two sheets together.
#1 contains 3 names and the zip codes they service.
#2 contains a list of names and addresses.

I need for a column in the second sheet to populate the persons name
from Sheet 1 relative to the zip code.

i.e this name and address has this zip code and is serviced by this
person because sheet 1 says so.

Make sense?

Thanks!

Multiple Sheet Help
 

This can be done using the match function in Excel. Here's the
assumptions I made to write the equation:
1. Sheet1 Row 1 has the names of the 3 service men (A1, B1 & C1)
2. Column A holds the zip codes for service man 1, Column B for Service
man 2, etc.
3. Sheet2 Zip code is in column F, Starting at Row 2

Cell G2 =
"=IF(ISERROR(MATCH(F2,Sheet1!A:A,0)),IF(ISERROR(MA TCH(F2,Sheet1!B:B,0)),IF(ISERROR(MATCH(F2,Sheet1!C :C,0)),"Not
Found",C1),B1),A1)"

HTH

Charles

wrote:
I need a little excel help he

I'm trying to tie two sheets together.
#1 contains 3 names and the zip codes they service.
#2 contains a list of names and addresses.

I need for a column in the second sheet to populate the persons name
from Sheet 1 relative to the zip code.

i.e this name and address has this zip code and is serviced by this
person because sheet 1 says so.

Make sense?

Thanks!