Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

Address

Posted by Yalitza Rodriguez on January 25, 2002 8:42 AM

Can you help?
I have to type up about 400-Company address every time I’m shipping to them for the packing slip. I need a formula. For example, I have all the address on one sheet and a packing list on other sheet. I would like to just put in the Store# and for the address to appear without me typing it. I used to do it on Lotus 123, but I no longer use that program, and the formula I used on that program doesn’t work on Excel. Please help, thank you very much.

Re: Address

Posted by Scott on January 25, 2002 9:43 AM

You can set up your table in a column format where store appears in the first column, and the street in the second, city, state, zip in the third. Then you can use a vlookup to lookup the store number, and return the address.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.