I am trying to use VLOOKUP to grab the number of units sold based on the average cost. But, the issue is that there are multiple weeks that show movement at this same cost. I need to average them all together and show that number in the selected cell.
So far I have:
=VLOOKUP(D3 & AU3,Data!$A$2:$AJ$155894,32,FALSE)
I am using 2 different criteria to get the Average cost already is why I have the D3 & AU3.
Bookmarks