Hello,
I was wondering if someone can help me, this is kind of hard to explain.
I'm doing a V Look Up, where I want to look up a SKU in one spreadsheet and transfer the amount across into my other spreadsheet.
However if there are the duplicate codes and values I want it to add the amounts together.
I've attached an example that will hopefully help.
Regards, Kirk.
Bookmarks