INDEX Formula on multiple criteria (Google Sheets)

[ryansm05]

Hi,

I need an array like formula that will work with Google Sheets.

It needs to look down two specifics columns and match with set criteria - returning the first value from a third column.

Link below with detailed example if anyone could spare a few mins to help.

Formula Question

Sheet1 Individual,Team,Penalty Taker,25-2 35,56,1,Q),Formula that will look down column B and C and return the first match corresponding with '25' and '2' respectively (the answer should be 104 in cell A5) 81,56,2,*,This would need to work with Google Sheets - so array formulas may not work (?) ...

docs.google.com

Cheers
Ryan

 

[kweaver]

What about:

=index(A2:A8,ArrayFormula(match(D1,B2:B8&"-"&C2:C8,0)))

With D1 holding something like: 25-2 or '8-3

 

[Peter_SSs]

Hi Ryan. I have moved your thread. Please note the highlighted points below.

 

[ryansm05]

What about:

=index(A2:A8,ArrayFormula(match(D1,B2:B8&"-"&C2:C8,0)))

With D1 holding something like: 25-2 or '8-3

@kweaver Thanks so much - works a charm! :D

@Peter_SSs my bad. I'll post in correct forum going forward.

 

[Peter_SSs]

@Peter_SSs my bad. I'll post in correct forum going forward.

Cheers. No problem.