Easy one....Right?

E

egeorge4

I have a list/column of zip codes and a list of customer information.

How do I use my column of zip codes to extract the records/rows tha
contain that zip code??
 
P

paul

vlookup will do the job for you.If you have a 2 column table of your
customers and respective zip codes,=vlookup( a5,A1:a50,2,false).A5 is the
cell containing customers name,a1:a50 is the range of your table.However if
you want to type in a zipcode and return all the customers within that zip
code vlookup aint for you!
 
E

egeorge4

OK, I am trying to make the vlookup work but not real sure how.

My customer data is 59 columns (A thru BH) and 797 rows,
with the zip code in the first column "A".

I have pasted in below the customer info, the zip codes from
completions. It is in cells A805 to A853.

How do I specify to search the customer data range for matches from the
zip code range A805 to A853?
 
Top