I have a cell that refers to more than one worksheet and displays the result (value) when it finds the product from the two sheets. SheetA has two columns, of which column
A is the value and column
B is that product name. SheetB only has product name.
Below is my formula but it fails to display result of product value, instead it always displays
Not Found even though the product is found from the sheets.
Is there anything wrong with the formula?