Home > OS >  QUERY data only when value EXISTS in another sheet - Google Sheets
QUERY data only when value EXISTS in another sheet - Google Sheets

Time:03-28

I created a similar request 2 years ago: QUERY data only when email is not in another sheet - Google Sheets

But I'm now trying to do the opposite, by only querying data when it DOES exist in the other sheet.

Changing the operator to = seems to show nothings, when I thought it might be the opposite to <>

Shows everything that's not in "ONLY SHOW THESE IN QUERY"

WHERE A <>'"&TEXTJOIN("' AND A <>'",true,'ONLY SHOW THESE IN QUERY'!A1:A)...

Shows nothing

WHERE A ='"&TEXTJOIN("' AND A ='",true,'ONLY SHOW THESE IN QUERY'!A1:A)..

Here's the editable sheet: https://docs.google.com/spreadsheets/d/1H39uZNfQ_VyK-YUvFY1vdeAnVcd9Y_PLS2MdAxZTh9c/edit?usp=sharing

Thanks!

CodePudding user response:

If you want to stick with your current approach, you'll need to change your AND in the TEXTJOIN to OR, since no single entry in the first list will match all of the entries in your second list.

  • Related