My advice is to use MS Access - import the four sets of data into a single
table, then run a Make Table query against that table and ask it to return
unique records.

After you have the unique records in a new table, link in the 4 other
worksheets and run your queries there.

Make no mistake - you CAN do this in Excel, but it's the wrong tool for this
kind of job. A little like trying to drive a nail with the handle on a
screwdriver.

"triniti" wrote:

I have 4 worksheets that need to be consolidate into one to form a master
listing, there are known duplicates between worksheets - total ~30000 records
and 30 colums

name hours date project
x 1 10/01/2005 a
x 2 11/01/2005 a
y 1 12/01/2005 b

I then need to compare this master to 4 other worksheets to determine in
which sheet the record is located. Any easy way to do this ?

Tried CONCETENATE and VLOOKUP - keeps crashing :(