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
=MAP(H2:H14,I2:I14, LAMBDA(x,y, IFNA(FILTER(C2:F, A2:A = x, B2:B = y),"")))
| 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 |