How can I Use query to pull information from another google spreadsheet?

Question

HI I have two google spreadsheets one spread sheet has multiple tabs with various information. The second spread sheet is a master data list of patients names and correlating information. As of now I have the mater data tab that i pull this information from. I would just like to simply move it to a separate sheet spreadsheet. This is the formula I use to pull data from the data tab (FC). =IFERROR(ARRAYFORMULA(JOIN(CHAR(10),QUERY(FC!$A$2:F,"Select D Where B='"&A21&"'"))))

How do I move tab FC to its own spreadsheet and get the same outcome on this sheet?

Answer 1

If you separate the master sheet, you will have to import data from the slave spreadsheets using IMPORTRANGE('ID of the source',sheet1!A2:F) for instance and then apply query on it. Give a link to a simplified mockup.

Answer 2

use:

=IFERROR(INDEX(TEXTJOIN(CHAR(10), 1, QUERY(IMPORTRANGE("sheet's_url", "FC!A2:F"), 
 "select Col4 
  where Col2='"&A21&"'"))))

example:

=IFERROR(INDEX(TEXTJOIN(CHAR(10), 1, QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1BhBUDx9LKKQIC2zQbDM2IOhVAV6ppygbts2vT-NmhAM/edit#gid=0", "data!A1:F"), 
 "select Col4 
  where Col1='"&A1&"'"))))