Forum Discussion
Solved
2 inputs make 1 cell change
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 ...
See the attached version. I used a combination of INDEX and MATCH. The formula works for Kooideuren and Schachtdeuren.
i found it out my self but still if someone know a shorter way to make this formula please reply
"=IFS(AND(C5="KES 201";C6="Centraal openen");Materiaal!A4;AND(C5="KES 201";C6="Enkelzijdig Telescoop");Materiaal!A7;AND(C5="KES 600";C6="Centraal openen");Materiaal!A10;AND(C5="KES 600";C6="Enkelzijdig Telescoop");Materiaal!A13;AND(C5="KES 800";C6="Centraal openen");Materiaal!A19;AND(C5="KES 800";C6="Enkelzijdig Telescoop");Materiaal!A15)"
"=IFS(AND(C5="KES 201";C6="Centraal openen");Materiaal!A4;AND(C5="KES 201";C6="Enkelzijdig Telescoop");Materiaal!A7;AND(C5="KES 600";C6="Centraal openen");Materiaal!A10;AND(C5="KES 600";C6="Enkelzijdig Telescoop");Materiaal!A13;AND(C5="KES 800";C6="Centraal openen");Materiaal!A19;AND(C5="KES 800";C6="Enkelzijdig Telescoop");Materiaal!A15)"