I am quite lost here. I have asked Google in every way I know how to no avail.
I have the formula: =IFERROR(INDEX(Pivots!$F$11:$F$30,MATCH(TRIM(Export!H11),Pivots!$A$11:$A$30)),"")
It's matching the value on a worksheet EXPORT and looking for it on worksheet PIVOT. The problem is that when there is no match on the pivot that the export sheet is looking for instead of returning a blank, it returns the next value above that does have a match. (if shop 57 exists on the export tab where the formula lives and not on the pivot tab but shop 56 exists on both, shop 57 will return shop 56's pivot value throwing off the subtotal)
I know a workbook is preferred but I work for the DoD and would have to strip everything that makes up the pivot table rendering it useless anyway.
Bookmarks