Query Function

[tmiles101]

Hi,

Moderator edit: Google Sheets question

I'm trying to use the following Query function =QUERY('Employee & Management Details Report'!A4:J458, "select B where J contains '"C2,C3,C4,C5,C6"')")
I want the formula to select the contents of Column B where Column J (in a separate tab) contains any of the items in Column C but I'm receiving an error. Anyone understand what I'm doing wrong here?

 

[dwang]

In order to combine strings together, you need to use & in Google Sheets. For multiple criteria, you want to use matches

=QUERY('Employee & Management Details Report'!A4:J458, "select B where J matches '.*"&join("|",C2:C6)&".*' ")

 

[dwang]

Oops. I made a mistake. Sorry I can't find where to edit my reply, or if it's even possible.

=QUERY('Employee & Management Details Report'!A4:J458, "select B where J matches '.*"&join(".*|.*",C2:C6)&".*' ")

 

[tmiles101]

Thank you so much, that worked.

 

[tmiles101]

Oops. I made a mistake. Sorry I can't find where to edit my reply, or if it's even possible.

=QUERY('Employee & Management Details Report'!A4:J458, "select B where J matches '.*"&join(".*|.*",C2:C6)&".*' ")

Thank you so much!