LookUp/Match/INDEXing Question

[carl]

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

 

[Marcelo]

hi Carl

try:

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

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: