Query Function in Google Sheets- Looking for two names in one column also using import range

user_18346714 0
Viewed 90

Hello I am trying to pull two different names within the same column while pull from another column for example also using importrange.

=query(IMPORTRANGE("https://docs.google.com/spreadsheets/","Department Import!A:N"),"select * where Col7='Josh' Col7=""Da'rone"" and Col1=2022 ")

I keep getting an error with pulling from col7.

google-sheets-formula data-analysis google-sheets
1 Answers

You have the right idea but you are missing an operator. You need to include OR.

FORMULA

=query(IMPORTRANGE("https://docs.google.com/spreadsheets/","Department Import!A:N"),"select * where (Col7='Josh' OR Col7=""Da'rone"") and Col1=2022 ")

user_75020290
Related