What does 523 have to do with anything in your sample data?

--
Thanks,
Shane Devenshire


"SM1" wrote:

I am trying to create a spreadsheet for businesses within zip codes. What I
would like to do is enter a zip code ie: 90620, and have the business number
523 returned to be part of, and create a total as shown below.

Buena Park Zip 90620
La Palma Zip 90623
Cypress Zip 90630
Los Alamitos Zip 90720
Costa Mesa Zip 92626
Costa Mesa Zip 92627
TOPP Prospects 5,805

I am using Excel 2003