Compare cell values base on other columns

Hi there,

I have 2 worksheets and I'm trying to compare every cell values in a column, based on 3 other columns, like this:

Worksheet1:
ID1, ID2, ID3, result, etc...

Worksheet2:
ID1, ID2, ID3, result, etc....

Basically, I want to compare the result and see if they are equal, base on the same combination of ID's. I can't compare them directly because the sorting/ordering of both worksheets is different.

Should I look into using VLOOKUP? Or use a macro for this comparison?

Any help is appreicated, thanks

anyone?

Originally Posted by NBVC

Can you be more specific what you are looking up? Is it a combination of 3 different ID's in 3 adjacent cells? And you want to see if that combination occurs in another sheet in 3 adjacent cells? Then you want to see if the 4th column of those 2 combinations are equal?

Yes, this is what I'm looking for

Sheet1: ID1 | ID2 | ID3 | result1 | result2 | result3...
Sheet2: ID1 | ID2 | ID3 | result1 | result2 | result3...

So the combination of ID's determines the record and they are adjacent cells. The main difference is, the sorting of Sheet1 is based on the combination of ID's in ascending order, while Sheet2 is in no particular order.

What I'm trying to do is to compare if Sheet1 and Sheet2 have the same result values (result1, result2, result3, etc...), base on the combination of ID's. Both sheets should be identical and has about 1000 records on each. So I'm trying to see if there's an automated method to do the comparison, as supposed to by visualizing.

Thanks.