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
|