After further review, Bo's solution does not work. Using the table fields will not work for this problem, as the same Product/Position is found in multiple locations and does not keep the same pricing. That is why I created name ranges for each Product/Position and it's applicable location. Sorry for the confusion. Bo's solution does remove the Volatile reading in Aggregate and displays each instance of the array. So on right track, but I just need to do the same with the named ranges.
Sorry for thinking the solution was solved and creating additional confusion.
Bookmarks