Summing across XLOOKUPs

New Contributor

I'm trying to do a look-up between two sets of SKU/quantities which do not have entirely the same SKU information between the arrays.




As long as the fields between both sets of SKUs are the same, a simple XLOOKUP does the job handily for giving me a difference between them: 


"=XLOOKUP(D2,WoWPrevSKU,WoWCurr90DN-WoWPrev90DN)" (Left side array is Prev[ious], right side is Curr[ent])


Once I get to a point where the SKUs don't align, the sums go crazy wrong.


What I want to appear in that Trend cell is for the difference (either +/-) between the 90DFN cells in each array where the SKU is the same in both arrays.

2 Replies
best response confirmed by jparris (New Contributor)




Well, that's what I get for not thinking the process out further than trying to cram it all into one formula field! LOL Thank you, Hans!