Mar 28 2021 06:24 AM
hi,
i trying to make excel look at 2 inputs C5 (3 possible values) and C6 ( 2 possible values) and then put the outcome in cell D14
i am trying to do this with the formula IFS and when i ut in the values for C5 its all oke but when if try to mix in C6 i get lost ,
how has a idea for me
thanks fazantje
Mar 28 2021 06:49 AM
Could you describe in detail what the formula should do? It would be helpful if you attached a small sample workbook (without sensitive information)
Mar 28 2021 06:59 AM
Mar 28 2021 07:06 AM
hi,
in cell D14 is the Formula i am taking about, how it is at the moment it is correct but very very long
Thanks Fazantje
Mar 28 2021 08:33 AM
SolutionSee the attached version. I used a combination of INDEX and MATCH. The formula works for Kooideuren and Schachtdeuren.
Mar 28 2021 11:36 AM
@Hans Vogelaar bedank voor de formule
oh sorry English site off cores :) for the "deurcontacten" i still used my formula because i don't know how to edit your formula for this part bur thanks :)
greets Fazantje
Mar 28 2021 12:01 PM
See the attached version.
My formula can easily be adjusted for deurcontacten. For brandweerdeuren, I used a shorter IF formula.
Mar 28 2021 08:33 AM
SolutionSee the attached version. I used a combination of INDEX and MATCH. The formula works for Kooideuren and Schachtdeuren.