Forum Discussion
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 up from the B5, B4, B3 cells, etc...
I'll be grateful if someone could help with the right formula?
Thank you.
Freddy
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
15 Replies
- If I may recommend you add a file (without sensitive data) to show your project instead of a picture.You have to consider that the helper has to make the effort to design the file that already exists.This is very tiring from the start, so it is always good to insert a file.This way you will be helped faster and the helpers too, whereby they can give a faster and more tailored answer.Thank you in advance for your time and effort.
Nikolino
I know I don't know anything (Socrates)
Thank you, Nikolino, for your quick reply.
My apologies for inserting a picture instead of the file.
This was my first post and I am already learning.
Best regards
Freddy
- Everything is OK. You have received from Mr. Faraz Shaikh a proposed solution that suits you, as far as I have seen. I can't expect better than that.
Nevertheless, I would recommend adding a file (without sensitive data) the next time.
Thank you for your understanding
Nikolino
I know I don't know anything (Socrates)
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
Thank you, Faraz, for the quick reply and awesome solution.
I have learnt something and you made my day.
Best regards
Freddy
