=IF(COUNTIF($A$2:$A$7,B2)0,C2)

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karl" wrote in message
...
A B C
D
UPCA UPCB INVENTORY RESULT
55 55 10
56 57 9
57 56 8
90 80 4
80 90 3
17 15 2

I need a formula that will find matches between column A+B then Record the
data that is in Column C in D. B+C are related fields (fixed)