Forum Discussion

FreddyNoel's avatar
FreddyNoel
Copper Contributor
Sep 30, 2020
Solved

If Condition with text and multiple options

Hello, I am new to formula and trying to create one that shows a different result in the column Score "E" every time a number is entered in the Stars column "D". If 5 = Gold, if 4 = Silver, picked ...
Excel on Mac
Formulas and Functions
  • ExcelExciting's avatar
    ExcelExciting
    Sep 30, 2020

    Hi FreddyNoel ,

     

    There are many ways to handle it, please find below you may construct your formula using VLOOKUP. your source data should be in ascending order to get the results.

     

    =VLOOKUP(D4,$A$9:$B$13,2,TRUE)

     

     

    Attached is the sample file for your reference

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

ExcelExciting's avatar
ExcelExciting
MVP
Sep 30, 2020

Hi FreddyNoel ,

 

There are many ways to handle it, please find below you may construct your formula using VLOOKUP. your source data should be in ascending order to get the results.

 

=VLOOKUP(D4,$A$9:$B$13,2,TRUE)

 

 

Attached is the sample file for your reference

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

FreddyNoel's avatar
FreddyNoel
Copper Contributor
Sep 30, 2020

Thank you, Faraz, for the quick reply and awesome solution.

I have learnt something and you made my day.

Best regards

Freddy

Resources