Excel Formula
Budget: €8 – €30 EUR
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.
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.