Forum Discussion
Solved
If the column contains text/number, then return value
Excel 2016: In Sheet1 I have a complete list of products in which I need to somehow mark the products that are also in Sheet2, preferably so that the value is displayed in the next blank column, base...
Perhaps you shall use semicolon instead of comma as separator. Please open attached file, formula automatically will be translated into your locale, and it shall work.
I set the format of the whole column as text, I inserted the same formula as you have in the screenshot, I pressed enter and the same error popped up (it's in my language, but I found it in English). I am also sending an excel document.
Perhaps you shall use semicolon instead of comma as separator. Please open attached file, formula automatically will be translated into your locale, and it shall work.
Thank you very much, it already works!
temporalnaut , you are welcome