What function to use to print as text if cell contains certain words

Question

I have the column attached in the first picture What function can I use to print: IF a cell contains Large print Large, If a cell doesn't contain Large print Standard, If a cell doesn't contain Large & Standard print nothing/blank.

So far I made it with =IF(ISNUMBER(SEARCH("large",[@[SERVICE TYPE]])),"Large") to print True/False and after in another column =IF([@Column1]=FALSE,"Standard","Large"). But they also apply for other services as seen in the second table. I want for e.g. "Nursery Route Level 2" to print blank. Is it possible?

Thanks in advance!

https://i.stack.imgur.com/r0nQ2.png https://i.stack.imgur.com/tY9IG.png

question from:https://stackoverflow.com/questions/65932958/what-function-to-use-to-print-as-text-if-cell-contains-certain-words

Answer 1

Waitting for answers