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
Bookmarks