SOLVED

excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3191825%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3191825%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone!%3C%2FP%3E%3CP%3EI%20have%20issues%20creating%20the%20right%20excel%20formel.%26nbsp%3B%3C%2FP%3E%3CP%3E-%20I%20would%20like%20to%20examine%20the%20excel%20row%20(B3%3AR3).%3C%2FP%3E%3CP%3E-%20If%20there%20is%20no%20%22x%22%20in%20the%20row%2C%20the%20cell%20should%20contain%20%22GameChanger%22%2C%3C%2FP%3E%3CP%3E-%20If%20there%20is%20%22x%22%201-2%20times%2C%20the%20cell%20should%20contain%20%22Differentiator%22%3C%2FP%3E%3CP%3E-%20If%20there%20is%20%22x%22%203-4%20times%2C%20the%20row%20should%20contain%20%22MustHave%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20very%20happy%20for%20any%20help!%3C%2FP%3E%3CP%3EBest%2C%20Hannah%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3191825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3191980%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3191980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1313290%22%20target%3D%22_blank%22%3E%40Hannah997%3C%2FA%3E%26nbsp%3BThat%20could%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DLOOKUP(COUNTIF(B3%3AR3%2C%22x%22)%2C%7B0%2C1%2C3%7D%2C%7B%22GameChanger%22%2C%22Differentiator%22%2C%22MustHave%22%7D)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3192042%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3192042%22%20slang%3D%22en-US%22%3Eits%20not%20working%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3ENot%20trying%20to%20type%20a%20formula%3F%3CBR%20%2F%3EWhen%20the%20first%20character%20is%20an%20equal%20(%22%3D%22)%20or%20minus%20(%22-%22)%20sign%2C%20Excel%20thinks%20it's%20a%20formula%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%E2%80%A2%20you%20type%3A%20%3D1%2B1%2C%20cell%20shows%3A%202%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20get%20around%20this%2C%20type%20an%20apostrophe%20(%20'%20)%20first%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%E2%80%A2%20you%20type%3A%20'%3D1%2B1%2C%20cell%20shows%3A%20%3D1%2B1%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3192062%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3192062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1313290%22%20target%3D%22_blank%22%3E%40Hannah997%3C%2FA%3E%26nbsp%3BPerhaps%20you%20need%20to%20replace%20the%20comma's%20with%20semi-colons.%20Are%20you%20using%20English%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey everyone!

I have issues creating the right excel formel. 

- I would like to examine the excel row (B3:R3).

- If there is no "x" in the row, the cell should contain "GameChanger",

- If there is "x" 1-2 times, the cell should contain "Differentiator"

- If there is "x" 3-4 times, the cell should contain "MustHave".

 

I would be very happy for any help!

Best, Hannah

6 Replies

@Hannah997 That could like this:

=LOOKUP(COUNTIF(B3:R3,"x"),{0,1,3},{"GameChanger","Differentiator","MustHave"})
its not working
Not trying to type a formula?
When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula:

• you type: =1+1, cell shows: 2

To get around this, type an apostrophe ( ' ) first:

• you type: '=1+1, cell shows: =1+1

@Hannah997 Perhaps you need to replace the comma's with semi-colons. Are you using English Excel?

best response confirmed by Hannah997 (New Contributor)
Solution

@Hannah997 See attached file. It should "translate" to your local settings automatically.

Thank you so much!!!! It worked!
You really helped me out - I wish you a great start into the week !

@Hannah997 Glad I could help!