| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pull in address from another worksheet
Thank you so much for your help!!
"Barb Reinhardt" wrote: This is what you'll need =VLOOKUP(A1,WMstorelist 3_20_06!A2:E3678,FALSE) A1 is the store # that you want to match. Change as necessary, This assumes that the store #'s are sorted from low to high. "S. Hernandez" wrote: 1) WMstorelist 3_20_06 - the master store sheet 2) Column A - Store # 3) Column C - Address Column D - City Column E - State Column F - Zip 4) 3678 - Total Rows On the invoice sheet, the address info needs to go into columns Column N - Address Column O - City Column P - State Column Q - Zip Thanks!! "Barb Reinhardt" wrote: If you could give me the following information, I could give you a formula that works for your application: 1) What sheet is the information you need on? 2) What column is the store number in? 3) What column are the address, city/state, and ZIP code in? 4) How many rows of data do you have on this sheet? I can get you something close with that info. "S. Hernandez" wrote: I have two worksheets. The first is a master listing of all stores for a certain client. They are all assigned a store number. The second sheet is a list of all invoices, I need to be able to type in the store number and it pull up the street address, city, state and zip, all in different columns. Help please!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| How do I pull information from one worksheet to another using cer. | Excel Worksheet Functions | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Can I import my excel worksheet to my address book | Excel Discussion (Misc queries) | |||
Threaded Mode
