Doc1 I have individual sheets setup for each Game Week which list the football matches being played on that particular week.
Doc2 I have Individual sheet setup for each team.
I'm looking to pull the scores and team names from a certain row in Doc1 to Doc2 based on the team in Doc2
I've worked out how to do this manually but with 20 teams and 38 Game weeks that a lot of copy, pasting and changing 30,000+ cells to alter the column reference in.
The "Manual" code I've got working is:
=importrange("https://docs.google.com/spreadsheets/d/xxxxxx/edit#gid=xxxxxx","Game Week 1!A1")
I'd like to be able to set the team name in Doc2 and it automatically fill in the game week rows based on than name.
After a some time researching I've come up with this:
=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/xxxxxxxxxx/edit#gid=xxxxxxxxxx","Game Week 16!A1:A19"),B1,"Select * Row1,Row5")
But this seems to only want to return numbers and not text as it give me the error mesage:
Function QUERY parameter 3 expects number values. But 'Select * Row1,Row5' is a text and cannot be coerced to a number...
Any help would be great, as i'm at a bit of a dead end.
Below are screenshots of the "Game week 1" sheet set up and the individual "team" sheet.