ART DATA.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
AM | AN | AO | AP | AQ | AR | |||
1 | Refreeze No | S1 | S2 | S3 | S4 | S5 | ||
2 | 8c(GII),8c(GII) | 5BB,4BB | 5AA,5AB | 5BB | ||||
3 | 1 | 4BB | ||||||
Master |
ART DATA.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | CY NO. | Patient Name | S1 | S2 | S3 | S4 | S5 | ||
2 | 1 | CINDY HING | 8c(GII),8c(GII) | 5BB,4BB | 5AA,5AB | 5BB | 0 | ||
3 | 2 | ||||||||
4 | 3 | ||||||||
5 | 4 | ||||||||
CY NO |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B5 | B2 | =IFNA(INDEX(Master!$E$2:$E$4974,MATCH('CY NO'!$A2,Master!$AM$2:$AM$4974,0)),"") |
C2:C5 | C2 | =IFNA(INDEX(Master!$AN$2:$AN$4974,MATCH('CY NO'!$A2,Master!$AL$2:$AL$4974,0)),"") |
D2:D5 | D2 | =IFNA(INDEX(Master!$AO$2:$AO$4974,MATCH('CY NO'!$A2,Master!$AL$2:$AL$4974,0)),"") |
E2:E5 | E2 | =IFNA(INDEX(Master!$AP$2:$AP$4974,MATCH('CY NO'!$A2,Master!$AL$2:$AL$4974,0)),"") |
F2:F5 | F2 | =IFNA(INDEX(Master!$AQ$2:$AQ$4974,MATCH('CY NO'!$A2,Master!$AL$2:$AL$4974,0)),"") |
G2 | G2 | =IFERROR(INDEX(Master!$AR$2:$AR$4974,MATCH('CY NO'!$A2,Master!$AL$2:$AL$4974,0)),IFERROR(INDEX(Master!$AR$2:$AR$4974,MATCH('CY NO'!$A2,Master!$AM$2:$AM$4974,0)),"")) |
G3:G5 | G3 | =IFNA(INDEX(Master!$AR$2:$AR$4974,MATCH('CY NO'!$A3,Master!$AL$2:$AL$4974,0)),"") |
For S5 (IE cell G2), I would like to get 4BB , but it returns to zero instead can anyone help, please