Excel 2007 - combining worksheets to use for a mail merge

C

crazywatergirl

I am trying to do a mail merge, and the information I need is contained in
two separate excel workbooks.

The first workbook contains the names and addresses of individuals who
receive a specific item number. The second workbok lists the various item
numbers along with the price for each item.

Is there a function in Excel that I can use to add the pricing information
contained in the second workbooks to the first workbook, so that I can
successfully compplete my mail merge using one data source document?
 
S

Sheeloo

You can use VLOOKUP.
Assuming Col C in sheet 1 contains item# and sheet 2 contains item# in Col A
and Price in Col B then you can get price in Col D of sheet 1 by entering
this formula (assuming further that row 1 is header) in D2
=VLOOKUP(C2,Sheet2!A:B,2,FALSE)
and copying the formula down col D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Merging from an Excel file with graphics 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Grouping Names in Mail Merge 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Duplicate Mail Merge Record Every Time 5
Mail Merge query 1
Integrating information from Word to Excel (not mail merge) 1

Top