Forum Discussion
Rachel_K
Nov 16, 2020Copper Contributor
Vexing problem, can anyone help please?
Hello and thank you in advance, The problem I'm having is that the formula is correct and works (thanks to click and drag), but not all rows return the answer even though there is data in the sou...
- Nov 16, 2020That appears to be it! Thank you so much!
SergeiBaklan
Nov 16, 2020Diamond Contributor
You have too long texts in D17, D20 and D23. SEARCH() works only with ones which length is less than 255 characters.