regexif-statementgoogle-sheetsgoogle-sheets-formulatextjoin
Does the value of one cell exist in another column from a different spreadsheet?
Here in this first sample sheet, I want to know whether the value from one cell (i.e. E3) exists within a column (K:K) within another google sheet. (And then I want to know the same for the entire column)
You'll see where I've approximated a formula that explains what I want in T3, but I don't know what I really need it to say. I have the html code from the other sheet there, like you'd do in an import range, with the tab and range, but can you help form the formula, or am I just totally on the wrong track?
(this is the second sheet that it's looking in)
Solution
try:
=INDEX(IF(REGEXMATCH(E3:E, TEXTJOIN("|", 1,
IMPORTRANGE("1KwxGR5-0AzmQBgTRL2i0saY_4cvlWjjCtz67YjzRD8A",
"WI ECE Content Alignment!K2:K"))), "Y", ))
- How to combine all the words of a sentence extracted with a regex?
- How can I detect all symbols on mathematical operators on PHP using regex?
- RegEx for combining "match everything" and "negative lookahead"
- How to validate an Instagram username
- Parse video id and start time from differently formatted youtube URL strings
- Python - regex to grab specific lines from text
- how to escape texts for formatting in python
- Regex not correctly rejecting invalid music note values
- regex - error with result - too many occurence
- Parse a formatted, single-line string into an array of associative arrays with predefined column names
- How to split a string by any of multiple delimiters?
- std::regex escape special characters for use in regex
- Does lookbehind work in sed?
- Regex for complex delimited string with multiple parse patterns
- Parsing PDF tables into csv with php
- RegEx for "does not begin with"
- PHP regex starting and ending with < and > produces an unknown modifier warning
- Sanitize number by removing first digit then any consecutive zeros
- How to match one or more characters nominated in a regex character class?
- Sanitize a number which may include dollar symbols, hyphens and dots
- Validate a numeric filename which may only be between 01 and 12, then the file extension
- Regex for number check below a value (12)
- Validate a string containing a number, underscore, then an number with a maximum of 12 digits
- Regular expression that allows only a specific special character when it has a specific length
- java - regex pattern matching days, hours, minutes, seconds
- Regex pattern for matching words between two delimiters
- Matching a String in Python using regex
- How to match and extract string matching regular expression
- Problem subsetting a string from a filename
- Remove all non-alphanumeric characters but keep float values