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...
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.
Thank you once again!
1. You did not refresh the query.
2. I used the column "Sold-To" for matching. But now there are empty cells.
3. Explain the value in I21.
- Thank you! It works! Really appreciate this.
Hope you have a nice day ahead 😄
