MrExcel.com - Your One Stop for Excel Tips & Solutions

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.

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.