SOLVED

Vexing problem, can anyone help please?

%3CLINGO-SUB%20id%3D%22lingo-sub-1890991%22%20slang%3D%22en-US%22%3EVexing%20problem%2C%20can%20anyone%20help%20please%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1890991%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20and%20thank%20you%20in%20advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20I'm%20having%20is%20that%20the%20formula%20is%20correct%20and%20works%20(thanks%20to%20click%20and%20drag)%2C%20but%20not%20all%20rows%20return%20the%20answer%20even%20though%20there%20is%20data%20in%20the%20source%20table.%20The%20only%20thing%20that%20changes%20between%20rows%20is%20the%20row%20%23%20(this%20is%20intended).%20I%20have%2080%20rows%20on%20this%20sample%2C%20but%20will%20have%20a%20couple%20hundred%2C%20so%20any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20screenshot%2C%20and%20I%20have%20included%20a%20sample%20file.%20Thanks%20again%20for%20any%20assistance!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rachel_K_0-1605539679009.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233772i5F41F36B0415EB4C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rachel_K_0-1605539679009.png%22%20alt%3D%22Rachel_K_0-1605539679009.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1890991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1891099%22%20slang%3D%22en-US%22%3ERe%3A%20Vexing%20problem%2C%20can%20anyone%20help%20please%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1891099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869891%22%20target%3D%22_blank%22%3E%40Rachel_K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20too%20long%20texts%20in%20D17%2C%20D20%20and%20D23.%20SEARCH()%20works%20only%20with%20ones%20which%20length%20is%20less%20than%20255%20characters.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 source table. The only thing that changes between rows is the row # (this is intended). I have 80 rows on this sample, but will have a couple hundred, so any help would be greatly appreciated.

 

Sample screenshot, and I have included a sample file. Thanks again for any assistance!

Rachel_K_0-1605539679009.png

 

 

 

3 Replies

@Rachel_K 

You have too long texts in D17, D20 and D23. SEARCH() works only with ones which length is less than 255 characters.

Best Response confirmed by Rachel_K (New Contributor)
Solution
That appears to be it! Thank you so much!

@Rachel_K , you are welcome