I bet you meant something like:

=INDEX(D2:D20,MATCH(1,(A2:A20="ABC")*(((B2:B20=1)+ (C2:C20="xyz"))0),0))

Still an array formula.

(Just in case column B = 1 and column C = xyz at the same time.)



Bob Phillips wrote:

=INDEX(D2:D20,MATCH(1,(A2:A20="ABC")*((B2:B20=1)+( C2:C20="xyz")),0))

--
__________________________________
HTH

Bob

<S D wrote in message ...
Hello Dave, I used your previous post create and Index Match function so
that when I have an exact match in two columns it returns the value in the
third.
I have it set up right now so Column A="ABC" and Column B=1 it returns the
value in column D.

Is there a way to format it so two conditions must be met, but the second
condition could have eihter of two criteria?
For example: a way that Column A="ABC" and Column B=(1 OR "xyz")?
Another way I could format is to create another column so:
A1:A500="ABC" AND (B1:B500=1 OR C1:C500="xyz")

Bascially I need it to match ABC and then one of the following: 1, xyz.

Any help would be VERY much appreciated... many hours spent struggling
with this one!
Thanks!

--

Dave Peterson