Hi!

Assume Data Set 1 is on sheet1 and Data Set 2 is on sheet2.

For DS1:

=IF(SUMPRODUCT(--(Sheet2!B$2:B$4&Sheet2!C$2:C$4=B2&C2)),"Y","N")

Copy down as needed.

For DS2 just change the sheet references to Sheet1.

Biff

"wsteel" wrote in message
...
I have two data sets that I am trying to compa

Each set has three columns: A=Order Number, B=Customer, C=Amount. I am
trying to get a formula to compare the sets populated into column D to
show
whether the Order appears in the other data set

Data Set 1
Col A Col B Col C Col D
Order Cust Amt In Data Set 2
1 Acme 10 (Desired answer - Y, or True)
2 Bear 15 (Desired answer - Y, or True)
3 Dear 20 (Desired anser - N or False)

Data Set 2

Col A Col B Col C Col D
Order Cust Amt In Data Set 1
1 Acme 10 (Desired answer - Y, or True)
2 Bear 15 (Desired answer - Y, or True)
3 Charlie 20 (Desired anser - N or False)

I know I've seen similar posts, but I just have not been able to grasp it.
Any help is greatly appreciated.