View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Lookup depending upon 2 criteria

.. this formula does not require array-entering?

Inspiration on usage came from reading some posts by Teethless Mama. I'm not
sure why it works w/o array-entering, but it does. And that in itself, is
quite an advantage, IMO.

.. if A2:A5 contain actual date/time then a conversion would be needed ..


Agreed. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"vezerid" wrote in message
...
Max, how come and this formula does not require array-entering?

One more thing, if A2:A5 contain actual date/time then a conversion
would be needed (at least is needed in mine):

=INDEX(B2:B5,MATCH(1,INDEX((A2:A5=--"14/11/2008 20:00:00")*
(C2:C5="RELEASE"),),0))

Regards,
Kostis