SOLVED

2 inputs make 1 cell change

%3CLINGO-SUB%20id%3D%22lingo-sub-2240569%22%20slang%3D%22en-US%22%3E2%20inputs%20make%201%20cell%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2240569%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20trying%20to%20make%20excel%20look%20at%202%20inputs%20C5%20(3%20possible%20values)%20and%20C6%20(%202%20possible%20values)%20and%20then%20put%20the%20outcome%20in%20cell%20D14%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20trying%20to%20do%20this%20with%20the%20formula%20IFS%20and%20when%20i%20ut%20in%20the%20values%20for%20C5%20its%20all%20oke%20but%20when%20if%20try%20to%20mix%20in%20C6%20i%20get%20lost%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20has%20a%20idea%20for%20me%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20fazantje%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2240569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2240585%22%20slang%3D%22en-US%22%3ERe%3A%202%20inputs%20make%201%20cell%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2240585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1010791%22%20target%3D%22_blank%22%3E%40Fazantje%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20describe%20in%20detail%20what%20the%20formula%20should%20do%3F%20It%20would%20be%20helpful%20if%20you%20attached%20a%20small%20sample%20workbook%20(without%20sensitive%20information)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

6 Replies

@Fazantje 

Could you describe in detail what the formula should do? It would be helpful if you attached a small sample workbook (without sensitive information)

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)"

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

best response confirmed by Fazantje (New Contributor)
Solution

@Fazantje 

See the attached version. I used a combination of INDEX and MATCH. The formula works for Kooideuren and Schachtdeuren.

@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

@Fazantje 

See the attached version.

My formula can easily be adjusted for deurcontacten. For brandweerdeuren, I used a shorter IF formula.