+ 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
    300

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    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

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

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    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)

Similar Threads

  1. Find the nearest date in a range of dates formula (Google sheets)
    By kaytoc in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-20-2017, 05:20 PM
  2. Replies: 2
    Last Post: 03-07-2017, 04:35 PM
  3. Excel equivalent to Google Sheets' FILTER(range, condition)?
    By Trille in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2016, 06:09 PM
  4. Import function in Google Sheets
    By Bielbo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-27-2014, 06:15 AM
  5. [SOLVED] Selecting a sheet from a range - issue with hidden sheets.
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2013, 09:38 AM
  6. Copy and paste range w/o selecting sheets
    By bg18461 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2006, 09:01 PM
  7. Selecting a criteria range over two sheets?
    By Lord_Ilpalazo in forum Excel General
    Replies: 1
    Last Post: 07-29-2005, 02:06 PM

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