Forum Discussion
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 ...
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
A million thanks again, Nikolino.
You are a Wizard, doing magic with Excel.
Best regards
Frederic
Your welcome
I was pleased to be able to help you.
Nikolino
I know I don't know anything (Socrates)
I was pleased to be able to help you.
Nikolino
I know I don't know anything (Socrates)