Think I got it by using a macro that enters VLOOKUP commands into the
top 2 rows for the 3 columns and then ending the macro and manually do
a drag and fill for all the columns with data. Does this sound about
right or is there another way.


Range("B2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],'Store
Database'!R2C1:R3000C4,2,FALSE)"
Range("C2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],'Store
Database'!R2C1:R3000C4,3,FALSE)"
Range("D2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],'Store
Database'!R2C1:R3000C4,4,FALSE)"
Range("B2:D2").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("B2:D3"),
Type:=xlFillDefault
Range("B2:D3").Select

I then manually do the drag in fill for I cant figure out how to do it
automatically for the amount of rows with data will always change.

Thanks,



On Sat, 01 Mar 2008 18:51:42 -0600, "
wrote:

Have one workbook with two worksheets (Store Number and Store
Database)

Store Database has these headers
Store Address City Zip Phone Number

There are 3000 different stores with this information on this
worksheet


Store Number currently has the identical headers.
Store Address City Zip Phone Number

Here is the difference though and our challenge.

We get a list of stores each week that we need to do a match from the
Store Database sheet. So if Store number worksheet had 23 in A1 it
would retrieve the address, city,zip and phone number from the Store
Database sheet that has the same store number. This would happen to
various amounts of stores. Meaning sometimes our Store Number
worksheet would contain 1000 stores, sometimes more , sometimes less.

The store number list is supplied and we just copy it to the Store
Number worksheet.

Thoughts, Ideas, help <grin

Thanks