Excel: Index/match to return array
Loukianos Zavolas
Sheet1 & Sheet 2
I am looking for a way that can perform the following task in excel for each of the column A values:
- Match value
A2of sheet 1 to the right value in arrayA2:C2from Sheet2 and return the respective array beneath the matching column (in this caseA3:A4from Sheet2). - This array would then need to be used for a
COUNTIFfunction for finding valueB2within this returning array.
Sheet1 (Results)
user4039065
Try this in sheet1!c2 and fill down,
=COUNTIF(INDEX(Sheet2!A:C, 0, MATCH(A2, Sheet2!$2:$2, 0)), B2)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to order dropdown list in QuerySelectField
- Next: How to show organized data from rails helper content tag
Related
Related Related
- 1
VBA in excel, it should return an array
- 2
Excel search in Array and return column
- 3
Array formula does not return array (Excel 2016)
- 4
Excel DNA resize return array vertically
- 5
VLOOKUP return an array of all matches in Excel
- 6
How to return array to range excel vba
- 7
Function to search array and return boolean value excel
- 8
Excel VBA - Split array and return as list
- 9
Return number corresponding to entry within array in excel
- 10
Excel INDEX array return multiple results, combined with IF
- 11
Excel - INDEX(MATCH) or similar to return an array
- 12
Can INDEX function in Excel return an Array?
- 13
Return array from INDEX function in Excel?
- 14
Pulling data from big excel datatable with incremental column in Vlookup or IndexMatch without zeros
- 15
Excel function to return values in Array1 but not in Array2
- 16
Pass Excel Range in VBA Function, Process as Array, and Return Result
- 17
Excel - Find a value in an array and return the contents of the corresponding column
- 18
excel VBA - return Criteria1 Array from an Autofilter
- 19
Excel: return name of column with highest value in a non-continuous array
- 20
sort, remove duplicates and blanks, return numbers only in an excel vba array
- 21
Excel UDF to return array from ACE SQL recordset
- 22
Excel array function return all fields found with index and match
- 23
How do I return an array from a vba function in Excel?
- 24
Excel Return another cell value if a match is found in an array of list
- 25
excel VBA - return Criteria1 Array from an Autofilter
- 26
Excel to return matched value in rows from a column array
- 27
excel vba function return array and paste in worksheet formula
- 28
Return String array from C++ DLL to VBA(Excel)
- 29
Combining SUMIF with VLOOKUP or IndexMatch
Comments