Problems with multiple matches inside an index-function

Hi guys.

I want excel 2007 to do the following. Get a value from a row in column O where these three things can be find
One date: column C contains the dates and B1162 is the value I want
Two ID's: columns A and D contain the ID's, where D1161 and D1159 are the two matches I want to do.

This function has worked before but now gives me a #Value! error

=INDEX(O1:O1157;MATCH(1;(A1:A1157=D1161)*(C1:C1157=B1162)*(D1:D1157=D1159);0))

There are some occasional div by 0 in the O-column but has not been a problem before. There are no duplicates that can fit these 3 criteria.

That is an array formula - did you remember to use CTRL-Shift-Enter to commit it?

Hope this helps.

Pete

Originally Posted by Pete_UK

That is an array formula - did you remember to use CTRL-Shift-Enter to commit it?

Hope this helps.

Pete

I did not remember it and it solved my problem.
Thanks a bunch Pete!