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