Hello good day all,
I would like to enquiry on index and match formula which I use on my data failed. I been looking on video but still unable to get the correct formula. I have a data and a sheet for return.
On the other tab(Sheet), I need to have the return to submit to my supervisor
Cell A2 =INDEX('Full Namelist'!,1,MATCH("Just Pass",'Full Namelist'!$E$1:$E$6,0))
Cell B2 =Vlookup(A2, 'Full Namelist'!$A$2:$G$6, 1, False)
I tried to drag down cell A2 to A4 it came out all same ID.
Anyone please guide me on this.
Thank You.
I would like to enquiry on index and match formula which I use on my data failed. I been looking on video but still unable to get the correct formula. I have a data and a sheet for return.
A | B | C | D | E | F | G | |
1 | ID | Name | Gender | Result | Grade | Subject | Remarks |
2 | T001 | Candy | Female | 58% | Just Pass | English | |
3 | T002 | Fiona | Female | 76% | Pass | English | |
4 | T003 | Jeff | Male | 38% | Fail | English | |
5 | T004 | John | Male | 93% | Pass | English | |
6 | T005 | Matt | Male | 69% | Just Pass | English |
On the other tab(Sheet), I need to have the return to submit to my supervisor
A | B | C | D | E | |
1 | ID | Name | Gender | Result | |
2 | |||||
3 | |||||
4 |
Cell A2 =INDEX('Full Namelist'!,1,MATCH("Just Pass",'Full Namelist'!$E$1:$E$6,0))
Cell B2 =Vlookup(A2, 'Full Namelist'!$A$2:$G$6, 1, False)
I tried to drag down cell A2 to A4 it came out all same ID.
Anyone please guide me on this.
Thank You.