chappers
Reputation: 466
Query where values contain values from another sheet
I need to query a sheet in another sheet and return and filter a list by matches containing. Heres my sheet:
Sheet2:
Sheet1:
Upvotes: 1
Views: 45
Answers (1)
player0
Reputation: 1
use FILTER instead like:
=FILTER(Sheet2!A:B, REGEXMATCH(Sheet2!A:A, TEXTJOIN("|", 1, D2:D)))
Upvotes: 1
Related Questions
- Google Sheet query where literal string contains field value
- SQL exact match in query for Google Sheets
- Query does not filter from two values separated by | in NOT CONTAINS string
- Google Sheets Query > Filter rows based on text in a string
- Query Google Sheets - how to match partial String
- Get values from other sheet based on other cell values
- Google Sheets multiple query matching words and numbers
- How to match two cells in different sheets in Google Sheet using QUERY function?
- Google Sheets query return all rows if they match any value in a column on another sheet
- Google Sheets query where other sheet equals