+ Reply to Thread
Results 1 to 4 of 4

Import Range Selecting Range [Google Sheets]

  1. #1
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    230

    Import Range Selecting Range [Google Sheets]

    Hey,
    I am putting in an import range on google sheet which will import data from a different google worksheet, but I am having trouble selecting the range.
    I need the range to be From A to F and AB , how can I add the AB row into the import range to pull data from AB Row.

    See attached screenshot for formula:
    Attached Images Attached Images
    Last edited by 6StringJazzer; 10-29-2018 at 12:03 PM. Reason: Moved from Excel Functions, IMPORTRANGE is exclusive to Google Sheets

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    2,795

    Re: Import Range Selecting Range [Google Sheets]

    I haven't as yet found any syntax that works with IMPORTRANGE, but you can always return the entire range and then wrap that in a QUERY call:

    =QUERY(IMPORTRANGE(url, entire table), "Select Col1, Col2, Col3, Col4, Col5, Col6, Col28", -1)
    Rory
    There's a row going on down near Slough

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    18,874

    Re: Import Range Selecting Range [Google Sheets]

    Have you tried "A:F, AB:AB" for the second argument of IMPORTRANGE?
    If posting code please use code tags, see here.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    2,795

    Re: Import Range Selecting Range [Google Sheets]

    Yep. Did it work for you?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1