Try:
Code:
--------------------
=INDEX(A1:A9,MATCH(1,("L-1234"=B1:B9)*(ISNUMBER(MATCH(C1:C9,{"Homer","Janss en","Smith"},0)))*(E1:E9="plastic"),0))
--------------------
confirmed with CTRL+SHIFT+ENTER
or
Code:
--------------------
=INDEX(A1:A9;MATCH(1;INDEX(("L-1234"=B1:B9)*(ISNUMBER(MATCH(C1:C9;{"Homer";"Janss en";"Smith"};0)))*(E1:E9="plastic");0);0))
--------------------
normally entered with just ENTER
--
NBVC
Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile:
http://www.thecodecage.com/forumz/member.php?userid=74
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=109827