Forum Discussion
Solved
VLOOKUP returning sum of values with common value in one row
Hi all, my ERP spits out this report format, which I need to summarize into filterable report. We are a trading company, so we track our purchase and sales back-to-back in any single transaction. Eac...
I have a solution but there are differences in C18, G17 and G18.
Please explain these results.
Sorry, I forgot to replace the 'real' names with examples.
I've updated the expected results. Please have another look. Thanks!
Would you be able to help me again with the PQ in the attached file? I have realized there are some differences in my ERP format.
https://docs.google.com/spreadsheets/d/1AAC88zMQaj5X_r3rJxOeIJEeJ4iKwa5D/edit?usp=sharing&ouid=103441876597334769631&rtpof=true&sd=true
Thank you once again!
