I have a sheet that brings through several products per line and then we manually add in lines and split them down so that each product gets it's own line, which we use as a mail merge later.
What I want to do is make sure that the products we are manually adding are correct (it's a drop down) so I want to ensure that the manually added cell is contained in the original cell.
I have put an example below, so the yellow collum is what we manually enter and I want to say in the error column if "Description" contains "product" then True if not False, so if "orange cake" was accidently selected for this order it would know this was not in the description and would error!
I know how to use the Contain formula if I am typing something in but don't know if it's possible to use the content of another cell (in my case "Product" ) to get it to work.
