Compare two Excel worksheet

[Alexce]

I need to compare two excel worksheet. worksheet1 contain the five field name , address ,city,state and worksheet also contain the same fields. Now i need to find out the record which is not available in worksheet2.

 

[Jaye7]

You could put a vlookup in a column of your sheet which would show you what wasn't found.

Type the following in your cell and autofill down the page.

=VLOOKUP(A1,G:G, 1, FALSE)

 

[Jaye7]

Sorry that was an example, it won't work for what you want, this would if you placed it in a sheet and your values to search for were in sheet2.

=vlookup(A1, Sheet2'!A:A, 1, false)

 

[Robert Mika]

If you want to compare the whole row of data you can use CONCATENATE function to merge the 5 values into one and then use INDEX/MATCH or MATCH only to lookup on your data.