Zip code lookup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a prospect list for a given State. It contains all companies of a certain size in the state. I need to find all customers that are in my territory. I have a list of 331 zipcodes in my territory. How would I find all customers in the state that are in my zipcodes. Ideally I would be able to put the company records into a new worksheet

Can this be done

Thanks
 
Hi
one way:
Assumptions:
- you have your list of your zipcodes in the sheet 'zip' in column A
- your comapnies are on a separate sheet with the zi code also in
column A

Enter the following formula on the company sheet
=IF(COUNTIF('zip'!$A$1:$A$331,A1)>0,"in my territory","not in my
territory")
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

simond said:
I have a prospect list for a given State. It contains all companies
Click to expand...
of a certain size in the state. I need to find all customers that are
in my territory. I have a list of 331 zipcodes in my territory. How
would I find all customers in the state that are in my zipcodes.
Ideally I would be able to put the company records into a new
worksheet.
 
Does the zipcode list also contain the state in a column.. If it doe
you could use an if statment between the two worksheets, and use th
state from the client list against the state in the zip code list
 
Back
Top