| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy one....Right?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy one....Right?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy one....Right?
Try this:
Data then Filter then Autofilter. -- Richard "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy one....Right?
Hi
egeorge4 vlookup command will be most effective and working try this "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy one....Right?
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? -- egeorge4 ------------------------------------------------------------------------ egeorge4's Profile: http://www.excelforum.com/member.php...o&userid=30259 View this thread: http://www.excelforum.com/showthread...hreadid=541418 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy question? Page numbers | Excel Discussion (Misc queries) | |||
| OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
| Should be really easy lookup ! | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| Easy way to sum multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
