Assume first name, last name, and company are in columns A, B, C
respectively.
=IF(ISNUMBER(MATCH(CONCATENATE(A1,B1,C1),'[File2]Sheet1'!$A$1:$A$100,0)),"Matched","not matched")

You have to enter the correct cell references to concatenate (join) above,
as well as the correct file name and sheet name and match range for the
external file.

If you do this correctly, where a match between the concatenated fields in
file 1 and the match range in file 2 occurs, "Match" will be returned in the
cell in which the above formula is entered, else "not matched" will be
returned.

Any questions, post back.

Dave



--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Stephanie" wrote:

Hello- my first post to the Excel group. I'm new on 2003 (SP2).

I have existing records of FirstName, LastName and Company.
I'm planning to upload additional records of FirstName, LastName and Company
and want to make sure that I don't upload any already exisiting records.

How can I compare FirstName, LastName and Company from one file (all 3
together would make the record "unique") against FirstName, LastName and
Company from another file?
Thanks for your help!