IFS gone now what?

[roc_ent]

Hi all,

So I'm trying to figure out what I need since it seems that the IFS formula has been taken away.

I have several questions that students need to answer, and their choice from a drop down list is in cells
H3 and the list is Agree, Disagree, Not Applicable. The results will be tabulated in cell AX where agree will be 10, disagree would be 5, n/a 0.

Can anyone help me out on this. It seems so basic but just can't figure it out. Thanks in advance.

 

[Trebor76]

Hi roc_ent,

Dose this do what you're after:

=VLOOKUP(H3,{"Agree",10;"Disagree",5;"Not Applicable",0},2,FALSE)

Regards,

Robert

 

[roc_ent]

Hi roc_ent,

Dose this do what you're after:

=VLOOKUP(H3,{"Agree",10;"Disagree",5;"Not Applicable",0},2,FALSE)

Regards,

Robert

Perfect, thank you so much .........

 

[Trebor76]

Thanks for the feedback and you're welcome