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