M
mariekek5
Hi, in case I use the following formula:
=INDEX(A1:A9;MATCH(1;("L-1234"=B1:B9)*("Homer"=C1:C9);0))
Is it possible to find the match with 'Homer OR Janssen', instead of just
'Homer'?
And also, can I ask for an extra criteria from another column using AND?
So what I want is a match with the row which contains:
'L-1234' in column B;
AND 'Homer' OR 'Janssen' OR 'Smith' in column C;
AND 'plastic' in column E.
I really hope somehow this is possible.
Thanks a lot in advance.
Marieke
=INDEX(A1:A9;MATCH(1;("L-1234"=B1:B9)*("Homer"=C1:C9);0))
Is it possible to find the match with 'Homer OR Janssen', instead of just
'Homer'?
And also, can I ask for an extra criteria from another column using AND?
So what I want is a match with the row which contains:
'L-1234' in column B;
AND 'Homer' OR 'Janssen' OR 'Smith' in column C;
AND 'plastic' in column E.
I really hope somehow this is possible.
Thanks a lot in advance.
Marieke