Using a query with multiple results in a subsequent query - Google Sheets

Question

I have a query that returns 2 or more results.

I want to be able to pass ALL the results, one-by-one to power another query. I decided to embed the queries.

=IFERROR(QUERY('Sheet1'!A1:J36,"SELECT J,B,C,D,E,F,G,H WHERE J Contains '" & B11 & "' AND B='" & QUERY('Sheet2'!$A$3:$AR$103,"SELECT D WHERE " & VLOOKUP($B11,'Test Sheet'!$A$33:$B$43,2,FALSE) & "='Yes' AND (AR='High' OR AR='Low') ORDER BY AH desc" ,0) & "' ORDER BY G desc" ,1),"No Results")

The query as a whole runs successfully, however only the first result of the initial query is passed to the outer query. This means I don't get all the matches I am expecting.

Is there a way of accomplishing this?

can you share a sample sheet of this stuff? I think i can help, and simplify quite a bit, but it's impossible in the abstract — MattKing
– MattKing, Commented Apr 29, 2020 at 18:51

MattKing · Accepted Answer · 2020-04-29 19:53:04Z

1

I think this is what your'e trying to do, on the MK.Help tab in cell A74.

=IFERROR(QUERY('Interventions V0.2'!A1:J39,"SELECT J,B,C,D,E,F,G,H WHERE J Contains '" & B11 & "' AND B matches'" & JOIN("|",QUERY('Biomarker Ref. Sheet (Static)'!$A$3:$AR$103,"SELECT D WHERE " & VLOOKUP($B11,'Test Sheet'!$A$33:$B$43,2,FALSE) & "='Yes' AND (AR='High' OR AR='Low')",0)) & "' ORDER BY G desc" ,1),"No Results")

answered Apr 29, 2020 at 19:53

MattKing

7,80310 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user20414 Over a year ago

Thanks Mike, the addition of JOIN worked perfectly.

Collectives™ on Stack Overflow

Using a query with multiple results in a subsequent query - Google Sheets

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related