+ Reply to Thread
Results 1 to 5 of 5

Indexing a different workbook in google sheets

  1. #1
    Registered User
    Join Date
    05-17-2021
    Location
    usa
    MS-Off Ver
    unsure
    Posts
    3

    Indexing a different workbook in google sheets

    sorry if this is not the right place to post this- i have not found a forum place for google sheets

    how can I import a range from a different gsheet into the INDEX formula
    i tried
    =index(importrange("URL","Sheet1!B2:G1285"),MATCH(G3,B2:B1285,0))


    and i got this error:
    Circular dependency detected. To resolve with iterative calculation, see File > Spreadsheet Settings.

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,133

    Re: Indexing a different workbook in google sheets

    Instead of "URL" you have to supply the Sheet ID of the other Google Sheet...

    The Sheet ID will be something like this;

    Please Login or Register  to view this content.
    which you can get it from the address bar of the browser when you open the other sheet....excluding the "/edit#gid=0" part.

    .

  3. #3
    Registered User
    Join Date
    05-17-2021
    Location
    usa
    MS-Off Ver
    unsure
    Posts
    3

    Re: Indexing a different workbook in google sheets

    sick! that worked- its not giving me the error now
    BUT now its telling me it cant find what is in G3

    so, help me wrap my head around this
    I have Sheet A and Sheet B. Both are the same workbook, but Sheet B is the new version. they have the same column blah blah
    so I'm basically trying to vlookup to the left. Find the matching number in column G, but give me whats in column B on sheet A and put it in column B on sheet B.

    so
    =index(importrange("URL","Sheet1!B2:G1285"),MATCH(G3,B2:B1285,0))
    So in the index side I'm telling it to look ok Sheet A in the range of columns B:G
    and to match what is in G3, and give me whats in B of that line? if that right?


    Sorry, I'm so bad at all this stuff and i need to like draw it out to understand

  4. #4
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Indexing a different workbook in google sheets

    Hi Melissa,

    Is it possible you could share a copy of your sheet with the permissions set for “Anyone with link can EDIT”? It might make things easier to solve and to explain your problem.

  5. #5
    Registered User
    Join Date
    05-17-2021
    Location
    usa
    MS-Off Ver
    unsure
    Posts
    3

    Re: Indexing a different workbook in google sheets

    its work thing so there is sensitive data. but let me see if i can mock up something similar. give me a bit to put that together

+ 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. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  2. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  3. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  4. Google Sheets - Move Row with "Complete" to a new sheet within the same workbook
    By msquared2 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-24-2018, 02:02 PM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  7. Replies: 0
    Last Post: 12-03-2014, 05:10 PM

Tags for this Thread

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