INDEX MATCH with IF help needed

[JamieT123]

I'm trying to index a column and match with multiple criteria if a1=yes and index
the same column with different criteria if a1=no. Here's a rough example of what
I've tried

{=IF(A1="yes",INDEX(D10:D20,MATCH(Y1&Y2&Y3,A10:A20&B10:B20&C10:C20),
IF(A1="no",INDEX(D10:D20,MATCH(Z1&Z2&Z3,A10:A20&B10:B20&C10:C20),"")}

It works up until the second IF so I think the problem is probably the closing off part, I'm pressing CTRL+SHIFT+ENTER but it doesn't work. It could also be the middle part where I'm closing off the first IF and opening the second, any ideas?

 

[63falcondude]

I think you're just missing some parenthesis. Try this:

{=IF(A1="yes",INDEX(D$10:D$20,MATCH(Y1&Y2&Y3,A$10:A$20&B$10:B$20&C$10:C$20)),IF(A1="no",INDEX(D$10:D$20,MATCH(Z1&Z2&Z3,A$10:A$20&B$10:B$20&C$10:C$20)),""))}

I also made the rows of your arrays absolute assuming that you will be dragging this formula down a column.