CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
TheGunner4
TheGunner4

Reputation: 61

Output rows from a range by several conditions in Google Sheets

please suggest a formula that would output rows from column C to column F if they match two conditions at the same time - values from column H equal to values from column A + values from column I equal to values from column B. If no matches are found, the row remains empty

File link: https://docs.google.com/spreadsheets/d/1IVBH3CLufPqWLsXRXSsMUNL7vsvnvgqxWZ7Cd_fknbg/edit?gid=0#gid=0

Upvotes: 0

Views: 51

Answers (1)

Patsytalk
Patsytalk

Reputation: 1059

Try this formula using MAP():

=MAP(H2:H14,I2:I14, LAMBDA(x,y, IFNA(FILTER(C2:F, A2:A = x, B2:B = y),"")))

Expected result

Column 3 Column 4 ?
Australia. NBL Championship Melbourne United Tasmania Jackjumpers 0 167 124
Australia. NBL Championship Perth Wildcats Melbourne Phoenix 0 204 158
Women Australia. NBL1 Central District Lyons (w) Southern Districts Spartans (w) 0
Australia. NBL Championship New Zealand Breakers Brisbane Bullets 0 178 135
Australia. NBL Championship Cairns Taipans Illawarra Hawks 0 177 130
Australia. NBL Championship Adelaide 36th Sydney Kings 0 196 141
Women Australia. NBL1 Rockingham Flames (w) Bendigo Braves (w) 0
Australia. NBL Championship Melbourne Phoenix Melbourne United 0 180 131
Australia. NBL Championship 1 Matland Mustangs Knox Raiders 0
Australia. NBL Championship 1 Forestville Eagles Eltham Wildcats 0
Australia. NBL Championship Illawarra Hawks Brisbane Bullets 0 214 151
Women Australia. NBL1 Newcastle Falcons (w) Waverly Falcons (w) 0
Australia. NBL Championship Perth Wildcats Sydney Kings 0 175 137

Upvotes: 1

Related Questions