View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default 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