Hi all,
Hope someone can help please. I have written a index and match formula that works but I want to have more than 1 scenario in the formula. Thats when the formula do not work.
This works:
=INDEX(Database!$K$2:$K$6,MATCH(1,INDEX(($A18=Database!$D$2:$D$6)*(Sheet1!Z$14=Database!$L$2:$L$9)*(Sheet1!Z$17=Database!M2:M10),0,1),0))
I tried to nest 2 sets into a If statement but doesnt work. Or maybe there is another way.
=if(INDEX(Database!$K$2:$K$6,MATCH(1,INDEX(($A18=Database!$D$2:$D$6)*(Sheet1!Y$14=Database!$L$2:$L$9)*(Sheet1!Y$17=Database!M2:M10,if(INDEX(Database!$K$2:$K$6,MATCH(1,INDEX(($A18=Database!$D$2:$D$6)*(Sheet1!Y$14=Database!$L$2:$L$9)*(Sheet1!Y$17=Database!N2:N10),0)))))))
Appreciate the help in advance.
Ben
Hope someone can help please. I have written a index and match formula that works but I want to have more than 1 scenario in the formula. Thats when the formula do not work.
This works:
=INDEX(Database!$K$2:$K$6,MATCH(1,INDEX(($A18=Database!$D$2:$D$6)*(Sheet1!Z$14=Database!$L$2:$L$9)*(Sheet1!Z$17=Database!M2:M10),0,1),0))
I tried to nest 2 sets into a If statement but doesnt work. Or maybe there is another way.
=if(INDEX(Database!$K$2:$K$6,MATCH(1,INDEX(($A18=Database!$D$2:$D$6)*(Sheet1!Y$14=Database!$L$2:$L$9)*(Sheet1!Y$17=Database!M2:M10,if(INDEX(Database!$K$2:$K$6,MATCH(1,INDEX(($A18=Database!$D$2:$D$6)*(Sheet1!Y$14=Database!$L$2:$L$9)*(Sheet1!Y$17=Database!N2:N10),0)))))))
Appreciate the help in advance.
Ben