Index Match for Different Groups of Data

[Jonathan78]

Hello,

With a simple Index Match-formula I managed to retrieve values based on a name and date.

However the column I am applying the formula on has several months and several names on it. At this point I need to update the formula at the start of another month in column B with the corresponding name.

I know this sounds really vague so I added the file as an attachment.

As you will see in the attachment, the first month for John Brown works fine. But how do I let the formula know that when to adjust the name condition, in this case into Nathan Yellow.

I like to use one formula that can be copied down from top to bottom.
Note that it's not always a full month.

[canapone]

Hi,

I've changed the reference of the second MATCH

in D5:

=IF(B5="Dummy","",INDEX($I$4:$K$73,MATCH(B5,$H$4:$H$73,0),MATCH(LOOKUP(2,1/($B$4:B5="Dummy"),$C$4:C5),$I$3:$K$3,0)))

Hope it's a little help

Regards

[Jonathan78]

Thank you Canapone!
it works perfect