Excel 2007 - combining worksheets to use for a mail merge

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

 

[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