Hi
I tried to use the INDEX and MATCH stuff, but cannot work out how to do this where Variable1 in STAFF and Variable2 between DATEFROM and DATETO
Data
<tbody>
</tbody>
I want to retrieve the TEAM for give Staff (e.g. ANV) where the DATE (e.g. 22/11/2016) is between DATEFROM and DATETO
Any suggestions?
Thanks
TW
I tried to use the INDEX and MATCH stuff, but cannot work out how to do this where Variable1 in STAFF and Variable2 between DATEFROM and DATETO
Data
STAFF | DATEFROM | DATETO | TEAM |
AB | 01/11/2016 | 30/06/2021 | TEAM1 |
ANV | 01/11/2016 | 08/12/2016 | TEAM1 |
ANV | 09/11/2016 | 30/06/2021<strike></strike> | TEAM2 |
DS | 01/11/2016<strike></strike> | 30/06/2021<strike></strike> | TEAM2 |
JMG | 01/11/2016<strike></strike> | 30/06/2021<strike></strike> | TEAM1 |
<tbody>
</tbody>
I want to retrieve the TEAM for give Staff (e.g. ANV) where the DATE (e.g. 22/11/2016) is between DATEFROM and DATETO
Any suggestions?
Thanks
TW