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?

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

"crazywatergirl" wrote:

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