Importing an row from Doc1 to Doc2

by Necrovana   Last Updated September 10, 2019 14:03 PM - source

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:

...Error
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.

!]2



Related Questions



Pull value from one sheet from exact row and column input

Updated September 10, 2019 17:03 PM