Excel Formula

Hello, I am looking for the following formula: Excel with product list if eg in column A or B or C (article name, short description, long description). Now I want to put an attribute value in its own column. If the value "blue" is in column A, for example in A3, then the value should be copied into column D3, but only the respective search term, not the entire description. So eg Column/Row A3 LED Warning Beacon, Series X456, Size X86 - Warning Color blue, Warning Cover clear Now the formula in D3 should look for the word "blue" as an example, if this is available then it should also be copied into D3.