IFS problems

[roc_ent]

so I have reference cell say (B49) which has been formatted with a drop down list. The three entries are 1) Need, 2) Want, and 3) is Unsure. Now in F49 is where I want to get the answer to my IFS so if B49 is "Need" the results of F49 should be $10.00 if the results in B49 is "want" results in F49 should come to only $5.00 and finally if B49 is "Unsure" results should be zero in F49.

Can anyone help me on this please.

Thanks

 

[shaowu459]

=IFS(B49="Need",10,B49="want",5,B49="Unsure",)

 

[iliace]

I don't know if you need IFS necessarily. Have you tried CHOOSE?

F49 =CHOOSE(MATCH(B49, {"need","want","unsure"}, 0), 10, 5, 0)

or also you could use VLOOKUP:

F49 =VLOOKUP(B49, {"need",10;"want",5;"unsure",0}, 2, FALSE)

 

[shaowu459]

I agree with you, there are many ways to get the expected result, simply Vlookup, Lookup, Index+match, etc.

=VLOOKUP(B49,{"need",10;"want",5;"unsure",0},2,)

 

[iliace]

I agree with you, there are many ways to get the expected result, simply Vlookup, Lookup, Index+match, etc.

=VLOOKUP(B49,{"need",10;"want",5;"unsure",0},2,)

Sorry, didn't see your reply before I posted my edit