IF function formula

[SteveSJ]

Dear All,

I need your kind assistance to help me to formulate the IF function.

For e.g., when i select "Almost Certain" from the drop down list, i want the result to be "Catastrophic".

below are the result i wish:

If i select ""Almost Certain" from the drop down list, i want the result to be "Catastrophic".
If i select ""Likely" from the drop down list, i want the result to be "Major".
If i select ""Possible" from the drop down list, i want the result to be "Moderate".
If i select ""Unlikely" from the drop down list, i want the result to be "Minor".
If i select ""Rare" from the drop down list, i want the result to be "Insignificant".

I sincerely appreciate your kind help.

Best Regards,
Steve

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[SteveSJ]

I guess ive attached

[AliGW]

Easy VLOOKUP:

=VLOOKUP(C6,$A$15:$B$19,2,0)

Where C6 is the cell containing the drop-down.

In future, please use more descriptive thread titles.

[SteveSJ]

Hi Ali,

Thank you. Apologies for not clearly stating the requirement.
I have reattached the excel. Actually i wish to pick the result from A7(Regardless the option i select).
For e.g., If A7, i select "Almost certain", the formula able to pick the desired result from "Formula" tab.
In this case, If "Almost Certain", the formula should reflect "Catastrophic".

Hope this clarifies.

Regards,
Steve

[FDibbins]

Adjusting Ali's suggest is still the formula you need...
B7=VLOOKUP(A7,Formula!$A$2:$B$6,2,0)

[SteveSJ]

Hi Ford,

Thank you for your assistance.
Much appreciated.

Regards,
Steve

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[FDibbins]

Ali did the heavy lifting, but thanks for the feedback

[SteveSJ]

Hi yes i have given star, unfortunately, it only allows to give me star once

[AliGW]

You still haven't marked this thread as solved.