0

## 求解EXCEL函數多欄比對回傳對應數值?

### 1 個回答

1

iT邦大神 1 級 ‧ 2021-04-15 12:19:57

``````H3=IF(ISNA(INDEX(\$C\$3:\$C\$11, MATCH(\$G3,\$B\$3:\$B\$11,0), 0)),"", INDEX(\$C\$3:\$C\$11, MATCH(\$G3,\$B\$3:\$B\$11,0), 0)) & IF(ISNA(INDEX(\$E\$3:\$E\$11, MATCH(\$G3,\$D\$3:\$D\$11,0), 0)),"", INDEX(\$E\$3:\$E\$11, MATCH(\$G3,\$D\$3:\$D\$11,0), 0))
H4=IF(ISNA(INDEX(\$C\$3:\$C\$11, MATCH(\$G4,\$B\$3:\$B\$11,0), 0)),"", INDEX(\$C\$3:\$C\$11, MATCH(\$G4,\$B\$3:\$B\$11,0), 0)) & IF(ISNA(INDEX(\$E\$3:\$E\$11, MATCH(\$G4,\$D\$3:\$D\$11,0), 0)),"", INDEX(\$E\$3:\$E\$11, MATCH(\$G4,\$D\$3:\$D\$11,0), 0))
H5=IF(ISNA(INDEX(\$C\$3:\$C\$11, MATCH(\$G5,\$B\$3:\$B\$11,0), 0)),"", INDEX(\$C\$3:\$C\$11, MATCH(\$G5,\$B\$3:\$B\$11,0), 0)) & IF(ISNA(INDEX(\$E\$3:\$E\$11, MATCH(\$G5,\$D\$3:\$D\$11,0), 0)),"", INDEX(\$E\$3:\$E\$11, MATCH(\$G5,\$D\$3:\$D\$11,0), 0))
H6=IF(ISNA(INDEX(\$C\$3:\$C\$11, MATCH(\$G6,\$B\$3:\$B\$11,0), 0)),"", INDEX(\$C\$3:\$C\$11, MATCH(\$G6,\$B\$3:\$B\$11,0), 0)) & IF(ISNA(INDEX(\$E\$3:\$E\$11, MATCH(\$G6,\$D\$3:\$D\$11,0), 0)),"", INDEX(\$E\$3:\$E\$11, MATCH(\$G6,\$D\$3:\$D\$11,0), 0))
``````