Hello people,
I have the follow situation:
Table1:
BANK A - 02/01/2019 - 150,00
BANK B - 02/01/2019 - 10.000,00
BANK A - 04/01/2019 - 300,00
BANK C - 05/01/2019 - 500,00
BANK A - 09/01/2019 - 400,00
Table2:
BANK A - 02/01/2019
BANK A - 03/01/2019
BANK A - 04/01/2019
BANK A - 05/01/2019
BANK A - 06/01/2019
BANK A - 07/01/2019
BANK A - 08/01/2019
BANK A - 09/01/2019
BANK B - 02/01/2019
BANK B - 03/01/2019
BANK B - 04/01/2019
BANK B - 05/01/2019
BANK B - 06/01/2019
BANK B - 07/01/2019
BANK B - 08/01/2019
BANK B - 09/01/2019
BANK C - 02/01/2019
BANK C - 03/01/2019
BANK C - 04/01/2019
BANK C - 05/01/2019
BANK C - 06/01/2019
BANK C - 07/01/2019
BANK B - 08/01/2019
BANK C - 09/01/2019
And i need the follow Result in table 2:
BANK A - 02/01/2019 - 150,00
BANK A - 03/01/2019 - 150,00
BANK A - 04/01/2019 - 300,00
BANK A - 05/01/2019 - 300,00
BANK A - 06/01/2019 - 300,00
BANK A - 07/01/2019 - 300,00
BANK A - 08/01/2019 - 300,00
BANK A - 09/01/2019 - 400,00
BANK B - 02/01/2019 - 10.000,00
BANK B - 03/01/2019 - 10.000,00
BANK B - 04/01/2019 - 10.000,00
BANK B - 05/01/2019 - 10.000,00
BANK B - 06/01/2019 - 10.000,00
BANK B - 07/01/2019 - 10.000,00
BANK B - 08/01/2019 - 10.000,00
BANK B - 09/01/2019 - 10.000,00
BANK C - 02/01/2019 - 0,00
BANK C - 03/01/2019 - 0,00
BANK C - 04/01/2019 - 0,00
BANK C - 05/01/2019 - 500,00
BANK C - 06/01/2019 - 500,00
BANK C - 07/01/2019 - 500,00
BANK B - 08/01/2019 - 500,00
BANK C - 09/01/2019 - 500,00
The result i need is similar a Excel vlookup with relative reference - vlookup(value,range,index, -1)
I will be gratefull for any help.
