Index Match with VBA

[skatey]

Hi everyone!

I am working on a project that I need some help with. Thanks in advance!

The table below is the raw data file.

Type	ID	Result	Date
Name	ku	Joe	1/6/2022
Name	ku	Sam	2/6/2022
Name	ku	James	30/6/2022
Drink	ip	Sprite	2/6/2022
Drink	ip	Sprite	2/6/2022
Drink	ip	Fanta	30/6/2022

I need to be able to map the data according to the table below based on the date, it has to be the last day of the month. I will always have to map the 'Result' column based on the 'Date' in the raw data file.

Type	ID	Result
Name	ku	James
Drink	ip	Fanta

[Dante Amor]

Try this:

Please Login or Register  to view this content.

Test file: