Google sheets, how do I get regexmatch to find a text string in a list?
I am new here, I have tried search for this answer and I can't find the same question
I am a totally self taught spreadsheet-maker, so if I have done some weird stuff - Please don't judge too harshly!
So I am using REGEXMATCH, and it just doesn't seem to be working like it usually does, and I can't work out why.
=IF($A13="","",(IF(REGEXMATCH({$L$13:$L$18},$A13),"YES","NO")))
I have made a workbook example to show the dilemma-
https://docs.google.com/spreadsheets/d/1paNG9Q-AciYbIR3HSgW7vxqNJmJBexgpm2lkLn32PN8/edit?usp=sharing
I want each line to tell me if its CODE-ID is in a list of items. I am pretty sure I had this working at some point, but I can't remember what I have changed. The regexmatch seems to just be picking up whether the code is in the first cell of the list.
Can anyone tell me what I have done wrong? I want the YES/NO column to change as I add new CODE-IDs to the list.
The weird thing is, I have got other cells to work by breaking the code right down to the basic regexmatch formula and building it up again, but it wont replicate when I copy it to another line. I don't know how to show that in this example because it isn't working here.
Let me know if this makes sense,
Thank you kindly,
Ellie
use in I13:
=INDEX(IF(A13:A="",,IF(ISNUMBER(MATCH(A13:A, L13:L18, 0)), "YES", "NO")))
- Get PHP class property by string
- Find sub string between two capital words in a text
- Best way to split string into lines
- How to remove string before a certain delimiter in R?
- More elegant way to change format of date without multiple variables and substrings
- Partition a string into substrings that all have majority characters
- Error 'A value of type 'dynamic' can't be assigned to a variable of type 'String'.' in Dart 2.2
- split string only on first instance - java
- How do I get a substring of a string in Python?
- Does PHP have a feature like Python's template strings?
- "Palindrome recursive function" detects palindromes right but doesn't behave as expected
- python split string on multiple delimeters without regex
- Find values in data frame that don't contain specific string and replace them in R
- Remove all whitespace in a string
- Get substring between "first two" occurrences of a character
- Return a string array from a C++ function to Fortran
- Check if a JavaScript string is a URL
- What is the difference between a null terminated string and a string that is not terminated by null in x86 assembly language
- Insert hyphen after every n characters without adding a hyphen at the end
- What is the most efficient string concatenation method in Python?
- getting last character from a string that may or may not be unicode
- Split string in half by a delimiting substring
- PHP - Loopless way to split a string into a multidimensional array
- How can I capitalize the first letter of each word in a string using JavaScript?
- Replace a series of the same character by its number of occurrences in the series
- octal to string - trouble
- SQL Server Convert Table Contents into Merge Statement?
- How do I format numbers with leading zeros efficiently in Python?
- Math.abs(x) is not working properly for specifically -2147483648, giving NumberFormat Exception
- How to truncate C char*?