Re: [libreoffice-users] Find string within a range of cells

On Fri, 7 Feb 2025 at 09:43, Wade Smart <wadesmart@gmail.com> wrote:
> What I have unsuccessfully been trying to do is.
>
> SUM(CD6:CD15) + If within this range C6:C13 the string "Upper Swing Pin"
> is found, reference BG6:BG13 on whatever line that string was found and
> find the text "lb:" and grab the number to the right * BZ that row number
> and .. add back to the sum, which is BN17
>
> I have had problems from the start.
> In my sample worksheet C7 = Upper Swing Pin 272s 725w
> When I use Search or Find "Upper Swing Pin" it is not found.
>
> I was testing with this:
>
>
> =IF(ISERROR(SEARCH("Upper Swing Pin", C6:C13)), "Not Found", "Found")
> =IF(ISERROR(SEARCH("Upper", C6:C13)), "Not Found", "Found")
>
>
> both said not found.

My understanding is the the SEARCH function is for finding a string of
text **within** another text, not across a range of cells.
ISTM it will be necessary to do a FIND function for each individual
cell where the text might be located.



-- 
T. R. Valentine
A rich heart may be under a poor coat.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy