I am looking for anomalies within an inventory file. See attached.
Column A is an Amazon listing description and in Column B is the SKU in our warehouse management system. I am wanting to run a formula of some sorts from column B to A to find any discrepancies that stand out. Is there any way to search column A for the sku within column b and if the formula finds the sku within the description, the formula indicate that? If column A number is contained in column B, show me somehow.
Hopefully this makes sense.