My data looks like this:

Date Group BidEqual
20070904 1C 0.741
20070905 1C 0.787
20070904 3R 0.862
20070906 AE 0.957

I am trying to find a formula for ColC to complete this table...

Date Group BidEqual
20070904 1C 0.74
20070905 1C 0.78
20070906 3R "NotFound"
20070906 AE 0.957
20070908 B0 "NotFound"


Thank You in Advance

hi Carl

try:

=IF(SUMPRODUCT(--($B$7:$B$10=B13)*($C$7:$C$10=C13),(D7:D10))=0,"not
found",SUMPRODUCT(--($B$7:$B$10=B13)*($C$7:$C$10=C13),(D7:D10)))

assuming that the first data is on B7:d10 and the second on b13:d18

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carl" escreveu:

My data looks like this:

Date Group BidEqual
20070904 1C 0.741
20070905 1C 0.787
20070904 3R 0.862
20070906 AE 0.957

I am trying to find a formula for ColC to complete this table...

Date Group BidEqual
20070904 1C 0.74
20070905 1C 0.78
20070906 3R "NotFound"
20070906 AE 0.957
20070908 B0 "NotFound"


Thank You in Advance