JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
Hi,
Not sure if vlookup is the correct thing to use for this but i have data like below:
<tbody>
</tbody>
Now for example if a have a sheet with dates if row 1
<tbody>
</tbody>
Any idea how this could be done (formula / powerquery or vba) ?
any help appreciated
Not sure if vlookup is the correct thing to use for this but i have data like below:
Name | StartDate | EndDate |
John | 12/05/2019 | 15/05/2019 |
Luke | 14/05/2019 | 14/05/2019 |
Anna | 11/05/2019 | 16/05/2019 |
Alex | 14/05/2019 | 16/05/2019 |
<tbody>
</tbody>
Now for example if a have a sheet with dates if row 1
11/05/2019 | 12/05/2019 | 13/05/2019 | 14/05/2019 | 15/05/2019 | 16/05/2019 |
Anna | John | John | John | John | Anna |
Anna | Anna | Luke | Anna | Alex | |
Anna | Alex | ||||
Alex |
<tbody>
</tbody>
Any idea how this could be done (formula / powerquery or vba) ?
any help appreciated