+ Reply to Thread
Results 1 to 2 of 2

IMPORTRANGE Function Not Working

  1. #1
    Registered User
    Join Date
    01-20-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    1

    IMPORTRANGE Function Not Working

    I'm trying to use the formula below and add IMPORTRANGE but the importrange formula showing an error, would you please help?

    Original formula:
    =IFERROR(VLOOKUP(INDEX($B$2:$B$6,SUMPRODUCT(($A$2:$A$6=$A9)*($C$2:$I$6=B$8)*(ROW($B$2:$B$6)))-ROW($B$2)+1),$K:$L,2,0),"")

    Added Importrange:

    =IFERROR(VLOOKUP(INDEX((IMPORTRANGE("LINK","TAB!$B$2:$B$6")),SUMPRODUCT(((IMPORTRANGE("LINK","TAB!$A$2:$A$6"))=$A9)*((IMPORTRANGE("LINK","TAB!$C$2:$I$6"))=B$8)*(ROW(IMPORTRANGE("LINK","TAB!$B$2:$B$6)))))-ROW((IMPORTRANGE("LINK","TAB!$B$2")))+1),$K:$L,2,0),"")

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: IMPORTRANGE Function Not Working

    I would recommend you first do an importrange of ALL the data to a new sheet/s
    IMPORTRANGE("LINK","TAB!$A:$Z")

    AFTER that is done, then try referencing the imported data
    NEWSHEET!$A$2:$A$6

    This will make it much easier to find where the problem could be coming from.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

+ 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. [SOLVED] Google Sheets: Dragging down cells with IMPORTRANGE function
    By cjvdg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 10-27-2020, 07:30 PM
  2. transposing data + importrange function (GoogleDocs)
    By crodz2 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-06-2020, 05:27 PM
  3. [SOLVED] Google Sheets: IMPORTRANGE/TRANSPOSE NOT WORKING
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-17-2018, 12:36 PM
  4. [SOLVED] Importrange + Query function
    By golden2282 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2018, 02:56 PM
  5. Help with importrange() function and row movement [preferably Google Sheets]
    By demaster in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 04-18-2018, 12:26 PM
  6. Replies: 0
    Last Post: 04-18-2018, 11:27 AM
  7. ImportRange function for referencing images
    By Donovan` in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-16-2012, 04:09 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