1

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.

jarlh
  • 42,561
  • 8
  • 45
  • 63
Tanecha Campbell
  • 11
  • 1

1 Answers1

0

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 ")

Kevin P.
  • 907
  • 7
  • 18