Index Match With Unique Identifier

Hello,

Looking to create an Index/Match solution combined with a Pivot Table filter.

Please see attached. Obviously am not very proficient w/IndexMatch.

On sheet Pivot, columns D thru H need to be fixed, which should be easy enough but suspect I�ve been at it too long today and am spun around.

Complicating matters however, is that although the dates are correct for each �Project� in the pivot filter, the IndexMatch formulas need to be driven from the unique identifier �helper� in column K on sheet table.

Some projects will have the same dates as others -- so without the ProjectDate identifier driving the formulas --- sheet will be sometimes be inaccurate.

Hope this is clear enough.

This Forum�s assistance is always appreciated.

Thanks in advance,
- Mik

ComplexIndexMatchUniqueIDhelper.xlsx