I have two sheets:
I am trying to do a vlookup for the period selected which is July_week2 using a condition (present_absent =Absent) and fetch name and date from sheet2
The vlookup keeps repeating the first name it gets and doesnt continue down further
output:
Name2 06/07/2020
Name2 06/07/2020
It should be
Name2 06/07/2020
name3 06/07/2020
Formula : IF(VLOOKUP($D$7,Sheet3!A9:H1659,6,0)="Absent",VLOOKUP($D$7,Sheet3!A9:H1659,2,0))
How do I fix this?
Sheet1:
sheet2 as which has below data
I am trying to do a vlookup for the period selected which is July_week2 using a condition (present_absent =Absent) and fetch name and date from sheet2
The vlookup keeps repeating the first name it gets and doesnt continue down further
output:
Name2 06/07/2020
Name2 06/07/2020
It should be
Name2 06/07/2020
name3 06/07/2020
Formula : IF(VLOOKUP($D$7,Sheet3!A9:H1659,6,0)="Absent",VLOOKUP($D$7,Sheet3!A9:H1659,2,0))
How do I fix this?
Sheet1:
Period | July_Week2 |
Name | Date |
Period | Name | Date | Present_Absent |
July_Week1 | Name1 | 01/07/2020 | Absent |
July_Week2 | Name2 | 06/07/2020 | Absent |
July_Week2 | Name3 | 06/07/2020 | Absent |
July_Week2 | Name4 | 07/07/2020 | Absent |
September_Week2 | Name5 | 10/09/2020 | Absent |
July_Week2 | Name6 | 08/07/2020 | Absent |
August_Week2 | Name7 | 06/08/2020 | Absent |
July_Week1 | Name8 | 02/07/2020 | Absent |
July_Week1 | Name9 | 01/07/2020 | Absent |
July_Week2 | Name10 | 08/07/2020 | Absent |
August_Week3 | Name11 | 12/08/2020 | Absent |
September_Week2 | Name12 | 09/09/2020 | Absent |