Have a look at the VLOOKUP function in Help
Then come back with more details of how the data is set out in you two files
your two files
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"lmirrim" wrote in message
...
How do I go about merging two Excel 2007 worksheets (in the same workbook)
into one master list? I want to connect them using a common field, say,
LAST
NAME. How can I do this to create one master worksheet? Thanks.