Simple way to merge two spread sheets

**repke** · 03-25-2012, 03:22 PM

I'm using excel 2007 and frequently have to merge a couple worksheets together. My master spread sheet has a common store number and I generally have to add 2 or 3 items from my clients list. Example attached described below.

Store #1000 needs 10 pens and 10 markers for the upcoming sale in addition to the items they typically receive. In the past I put all of my work sheets from the master into one long list and sort by store number. I then do the same with the clients list and then insert them next to the store number so I can verify they all line up.

So this seems like a horrible approach but I have yet to figure out a if than statement that I can use.

Thanks in advance for your help.

Chris

**Special-K** · 03-25-2012, 08:46 PM

On the master sheet

in C1 enter
=VLOOKUP($A1,'new list'!$A$1:$C$11,2,0)

in D1 enter
=VLOOKUP($A1,'new list'!$A$1:$C$11,3,0)

now copy C1 and D1 down the columns

**repke** · 03-25-2012, 09:07 PM

Thanks for the quick reply - I will give it a try this evening!

**repke** · 03-26-2012, 12:56 AM

Is it possible for VLOOKUP to search the entire list? So if the two lists aren't in the same order the info would still be pulled. I'm sorry for not putting this in my example.

I'll see if I can post an updated example.

http://dl.dropbox.com/u/8268628/merg...20updated.xlsx

Thanks

**repke** · 03-29-2012, 12:50 AM

Special-K helped me get an idea of what would work and then this website had an exact match for what I needed. vlookup compares a cell from your master list to a range of cells from your 2nd list until it finds a match then copies the cell x number of columns over from the match. Nice.

http://dposorio.com/wordpress/4/how-...c-spreadsheet/