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("","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("","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.


Related Questions

Pull value from one sheet from exact row and column input

Updated September 10, 2019 17:03 PM