I have Monthly Mapping Files
Jan_DLoad, Feb_DLoad, Mar_DLoad xlsx Files.. Which has Date as Field
Date | Player |
01/01/2021 | MLKAS
01/01/2021 | BLOOM
Similiarly Feb File
01/02/2021 | KARMOS
01/02/2021 | CASSE
We have a Source File which needs to Look up these Files, The Source Files as Date Column called 'Actual Date'
For Ex: 18/01/2021 ,24/2/2021, 12/03/2021
This actual date needs to look up on the mapping files and check if the Actual Date is Jan then it has to retrieve information from Jan mapping File else if February then Feb - Mapping File etc..
Thanks to suggest..