Forum Discussion
index match - multiple criteria error?
=INDEX('array sheet'!B2:B385,MATCH(1,(O5='array sheet'!A2:A385)*(U5='array sheet'!C2:C385),0))
Great. I think it will work if you change the formula as above. The distribution center is in column C in the 'array sheet' and therefore the formula should have: (U5='array sheet'!C2:C385).
='INDEX('array sheet'!B2:B385,MATCH(1,(O5='array sheet'!A2:A385)*(U5='array sheet'!C2:C385),0))
Does this work in your sheet? The value from cell U5 is "BARN" and it appears in column C in the 'array sheet'. The value "DRD581IVO" from cell O5 should be in column A in the 'array sheet' i suppose. The "option ID" is in column B in the 'array sheet'.
However it is still not working :(, still giving me the pop up message "there's a problem with your formula"...
Im sorry I wanted to upload my file to help, but I cant seem to be able to add it!
Please let me know if you figure what the issue could be otherwise..?
Thanks a lot!!
=INDEX('array sheet'!B2:B385,MATCH(1,(O5='array sheet'!A2:A385)*(U5='array sheet'!C2:C385),0))Sorry i forgot to say that you have to enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
I tried to do that but it didn't seem to work so I must not be doing the right thing....
1. I enter the formula in the bar
2. then hold ctrl+shift+enter?
When I do so I get again the same popup
Sorry Quadruple_Pawn I am still quite beginner at more advanced formulas!!