Index Match Match - Google Sheets - Stack Overflow
Is it possible to do index match using multiple google sheets
Using INDEX MATCH to return multiple rows in Google Sheets - Stack Overflow
INDEX and MATCH across two sheets: a detailed explanation
What are the INDEX and MATCH functions in Google Sheets?
What are some advanced techniques for using INDEX MATCH in Google Sheets?
What is the difference between VLOOKUP and INDEX MATCH in Google Sheets?
I have data in different multiple google sheets; I'm very familiar with using index match in excel but not in google sheets.
is it possible to index one google spreadsheet and match the data in a different google spreadsheet? hope that makes some sort of sense.
Maybe consider the use of FILTER():
=FILTER(DATA!A:AF, B1&C1&E1=DATA!AA:AA&DATA!AD:AD&DATA!AC:AC)
For anyone else perusing this topic several years later, you can also use the query formula. This is a useful article to better help learn it: https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/
In this case, you can you use:
=Query(DATA!A:AF,"select * where AA = "&B1&" AND AD = "&C1&" AC = "&E1)`
The Query formula uses a version of the SQL to help you filter and return the exact data you need. I can't stress how useful it can be!
The string break and ampersands are necessary to reference a field outside of the data range notated in the first field of the Query formula.