🌐
Google Support
support.google.com › docs › answer › 3098242
INDEX - Google Docs Editors Help
MATCH: Returns the relative position of an item in a range that matches a specified value. OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference. If you set row or column to 0, INDEX returns the array of values for the entire column ...
🌐
Owox
owox.com › blog › articles › google sheets tips › how to use index match in google sheets: a complete guide
Master INDEX and MATCH in Google Sheets With Our 2025 Guide
June 1, 2026 - The INDEX function is a powerful tool, often referred to as the index formula in Google Sheets, that returns the value of a cell within a specified range based on given row and column numbers.
Discussions

Index Match Match - Google Sheets - Stack Overflow
I have two tables in Google Sheets. Table 1 is a list of contacts arranged vertically with multiple records appearing for each city. In Table 2, I'd like the city name to appear only once and the More on stackoverflow.com
🌐 stackoverflow.com
Is it possible to do index match using multiple google sheets
Use the IMPORTRANGE function to pull data in from the other sheet sources, to the sheet where you want to run your INDEX calcs: https://www.businessinsider.com/importrange-google-sheets?op=1 It's a gamechanging feature once you get it working. Prob easiest to have seperate tabs, and then chain together your index match query. Hope that helps, I use this for VLOOKUPs all the time, not smart enough to wrap my head around Index Match :) More on reddit.com
🌐 r/sheets
7
3
May 14, 2021
Using INDEX MATCH to return multiple rows in Google Sheets - Stack Overflow
I'm currently trying to use an INDEX/MATCH formula to return values from a data sheet into a summary sheet based on user entered criteria. This is the formula I have so far: =INDEX(DATA!A:AF,MATC... More on stackoverflow.com
🌐 stackoverflow.com
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference ... More on community.smartsheet.com
🌐 community.smartsheet.com
November 8, 2021
People also ask

What are the INDEX and MATCH functions in Google Sheets?
The INDEX function returns the value of a cell in a specified row and column within a range. The MATCH function searches for a value in a range and returns its position. Combined, they allow you to look up and retrieve data dynamically.
🌐
owox.com
owox.com › blog › articles › google sheets tips › how to use index match in google sheets: a complete guide
Master INDEX and MATCH in Google Sheets With Our 2025 Guide
What are some advanced techniques for using INDEX MATCH in Google Sheets?
Advanced techniques include performing two‑way lookups (combining row and column searches), using dynamic or named ranges, applying array formulas for multi‑criteria lookups, and handling errors with IFERROR.
🌐
owox.com
owox.com › blog › articles › google sheets tips › how to use index match in google sheets: a complete guide
Master INDEX and MATCH in Google Sheets With Our 2025 Guide
What is the difference between VLOOKUP and INDEX MATCH in Google Sheets?
VLOOKUP searches for a value in the first column of a range and returns a value from a specified column. INDEX and MATCH offer more flexibility: you can search in any column, perform left‑side lookups, and work with large datasets more efficiently.
🌐
owox.com
owox.com › blog › articles › google sheets tips › how to use index match in google sheets: a complete guide
Master INDEX and MATCH in Google Sheets With Our 2025 Guide
🌐
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › index match in google sheets – another way for vertical lookup
INDEX MATCH in Google Sheets – another way for vertical lookup
April 24, 2020 - A more convenient way to check the availability of various berries would be to place them in a drop-down list (E2) and refer your MATCH function to the cell with that list: ... You already know that Google Sheets INDEX MATCH looks your value up in a table and returns another related record from the same row.
🌐
GeeksforGeeks
geeksforgeeks.org › google sheets › google-sheets-index-match
How to Use INDEX MATCH in Google Sheets: Step-by-Step Guide - GeeksforGeeks
October 3, 2025 - The MATCH function is perfect for ... is in the 4th row). The INDEX function in Google Sheets retrieves the value of a cell based on its position within a specified range....
🌐
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › easy index match google sheets guide
Easy INDEX MATCH Google Sheets Guide
September 9, 2025 - ... Font ColorwhiteFont Opacity100%Font ... Opacity0% ... The MATCH function in Google Sheets returns the relative position or “INDEX” of an item within a range of cells....
🌐
SimpleSheets
simplesheets.co › blog › index-match-google-sheets
How To Use Index Match in Google Sheets
July 11, 2024 - This guide will discuss step-by-step how to use INDEX and MATCH together. The INDEX function in Google Sheets allows you to retrieve a value from a specific position in a range.
Find elsewhere
🌐
Stack Overflow
stackoverflow.com › questions › 72992776 › index-match-match-google-sheets
Index Match Match - Google Sheets - Stack Overflow
I have two tables in Google Sheets. Table 1 is a list of contacts arranged vertically with multiple records appearing for each city. In Table 2, I'd like the city name to appear only once and the
🌐
Coefficient
coefficient.io › home
Use INDEX and MATCH with Multiple Criteria in Google Sheets - Coefficient
September 2, 2025 - Build the formula starting with =INDEX(return_range, then add MATCH(lookup_value1&lookup_value2, and concatenate your lookup values ... Use array formulas by pressing Ctrl+Shift+Enter (Windows) or Cmd+Shift+Enter (Mac) to handle multiple criteria ...
🌐
SheetXAI
sheetxai.com › home › blog › index match in google sheets: complete guide with examples | sheetxai
INDEX MATCH in Google Sheets: Complete Guide with Examples | SheetXAI
December 1, 2025 - Try SheetXAI for freeor install from the marketplace · To do this manually, you need to use: INDEX and MATCH. Finds the row number where a value exists. Syntax: =MATCH(lookup_value, lookup_array, [match_type])
🌐
Smartsheet Community
community.smartsheet.com › home › get help › best practice
INDEX and MATCH across two sheets: a detailed explanation - Smartsheet Community
November 8, 2021 - Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
🌐
Google Sheets
sheets-pratique.com › en › functions › index-match
Google Sheets Functions: INDEX + MATCH
The INDEX function used with the MATCH function allows searching for a value in a range of cells...
🌐
Simular
simular.ai › workflow › how-to-index-match-by-criteria-in-google-sheets-excel
How to INDEX MATCH by Criteria in Google Sheets & Excel
August 13, 2026 - ... Each comparison (H2=A2:A1000, etc.) returns TRUE/FALSE values. Multiplying them turns TRUE into 1, FALSE into 0. Only rows matching all criteria become 1. MATCH finds the first 1; INDEX returns the corresponding value from E2:E1000.
🌐
Computer Tutoring
computertutoring.co.uk › index-match-google-sheets.asp
INDEX MATCH in Google Sheets
In the second argument, after the comma, you provide a number of the row that contains the value you want to return. Enter the Match Function. The Match function takes the place of the second argument of the INDEX function.
Published: January 29, 2025
🌐
Google Support
support.google.com › docs › thread › 230518206 › index-match-based-on-criteria-in-two-rows-and-one-column
Index Match based on criteria in two rows and one column - Google Docs Editors Community
August 15, 2023 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Top answer
1 of 1
3

I myself would not approach things the way you are doing in this sheet. (I always recommend using a separate sheet within your destination spreadsheet where IMPORTRANGE brings in all of the data from the source location, and then using that single sheet in the destination spreadsheet as the reference for all other formulas, such as the ones you're trying to use.)

In addition, your sheets are inaccessible (i.e., "Comment only"). So neither I nor anyone else would be able to setup an alternative method for you to consider.

That said, and working with what you do have, here is how you might adjust the B36 formula...

Here is the formula you originally wrote (and which is not working):

=INDEX(importrange("https://docs.google.com/spreadsheets/d/1mAssNMTGXcMcuYhjDWq6lNfWOdgUfI6FbGSWushGAMg/edit#gid=0",$J$1&"!A4:H26"),MATCH($A36,index(importrange("https://docs.google.com/spreadsheets/d/1mAssNMTGXcMcuYhjDWq6lNfWOdgUfI6FbGSWushGAMg/edit#gid=0",$J$1&"!A4:A26"))),match($J$2,index(importrange("https://docs.google.com/spreadsheets/d/1mAssNMTGXcMcuYhjDWq6lNfWOdgUfI6FbGSWushGAMg/edit#gid=0",$J$1&"!A4:H4"))))

Here is my edit to that formula structure (which should work):

=INDEX(IMPORTRANGE("1mAssNMTGXcMcuYhjDWq6lNfWOdgUfI6FbGSWushGAMg",$J$1&"!A4:H26"),MATCH($A36,IMPORTRANGE("1mAssNMTGXcMcuYhjDWq6lNfWOdgUfI6FbGSWushGAMg",$J$1&"!A4:A26"),0),MATCH($J$2,index(IMPORTRANGE("1mAssNMTGXcMcuYhjDWq6lNfWOdgUfI6FbGSWushGAMg",$J$1&"!A4:H4")),0))

Notice that you only need the spreadsheets ID number for IMPORTRANGE, not the entire URL. This just makes reading such formulas easier.

You also had mismatched sets of parentheses. This was your biggest issue.

And I recommend using the third parameter of MATCH to indicate what kind of match you're looking for. (Here, I assigned 0, which means "exact match only.")

Hopefully, you can use that as a model for editing your other formulas.

🌐
Google
developers.google.com › search central › documentation › seo starter guide: the basics | google search central
SEO Starter Guide: The Basics | Google Search Central | Documentation | Google for Developers
Before you actually do anything mentioned in this section, check if Google has already found your content (maybe you don't need to do anything!). Try searching on Google for your site with the site: search operator. If you see results pointing to your site, you're in the index.
🌐
Airboxr
airboxr.com › post › a-guide-to-index-match-in-google-sheets
A Guide to INDEX-MATCH in Google Sheets - Airboxr
September 24, 2021 - INDEX-MATCH in Google Sheets combines two different functions, namely, INDEX and MATCH. The MATCH function returns the relative position of an item within an array. The INDEX function fetches an item from an array given a specific position.
🌐
Statology
statology.org › home › google sheets: use index match with multiple criteria
Google Sheets: Use INDEX MATCH with Multiple Criteria
February 28, 2022 - =INDEX(reference,MATCH(1,(criteria1)*(criteria2)*(criteria3)*...,0)) ... The following example shows how to use this syntax in practice. Suppose we have the following data in Google Sheets that shows information for various basketball players: