Index Match between two dates

[Sthomson1984]

I'm working with a large data set which is an extraction from a current system. Unfortunately, the structure isn't great and I'm trying to re-organise the data.

I'm trying to 'extract' through index match a reference that is between two dates.

I've attached a template of what I'm trying to accomplish. The shaded area is where I've hardcoded numbers but would ideally have a formula do this.

Any help would be greatly appreciated.

Cheers
Sam

[bebo021999]

Change C1:E1 into real dates, custom format as:
"Compensation as @ "dd/mm/yyyy

Then using:

Please Login or Register  to view this content.