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.
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.
Hey, thanks! Is PQ an add-on? I think it's quite a steep learning curve, but I'll give it a try.
thank you once more
