I want to create a formula which will search for specific text in cell A7 and if this text is in there then it will add a given phrase into the cell Im typing in (currently N7).

Text to search in cell A7 "in 5%" Text to add in N7 "Limo Black"
Text to search in cell A7 "in 20%" Text to add in N7 "Dark Smoke"
Text to search in cell A7 "in 35%" Text to add in N7 "Medium Smoke"
Text to search in cell A7 "in 50%" Text to add in N7 "Light Smoke"
Text to search in cell A7 "in 70%" Text to add in N7 "Ultra Light"

Ill then copy this into the remaining cells to check A8, A9 etc

Thanks in advance