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!
--
paul

remove nospam for email addy!



"egeorge4" wrote:


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 that
contain that zip code???


--
egeorge4
------------------------------------------------------------------------
egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259
View this thread: http://www.excelforum.com/showthread...hreadid=541418