ExcelBanter - LookUp/Match/INDEXing Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LookUp/Match/INDEXing Question (https://www.excelbanter.com/excel-worksheet-functions/170144-lookup-match-indexing-question.html)

LookUp/Match/INDEXing Question

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

LookUp/Match/INDEXing Question

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