Forum Discussion

jimmytan9353's avatar
jimmytan9353
Copper Contributor
Mar 14, 2024
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...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Mar 14, 2024

jimmytan9353 

I have a solution but there are differences in C18, G17 and G18.

Please explain these results.

 

jimmytan9353's avatar
jimmytan9353
Copper Contributor
Mar 15, 2024

Detlef_Lewin 

 

Sorry, I forgot to replace the 'real' names with examples.

I've updated the expected results. Please have another look. Thanks!

 

    • jimmytan9353's avatar
      jimmytan9353
      Copper Contributor
      Mar 21, 2024

      Detlef_Lewin 

       

      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! 

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Mar 21, 2024

        jimmytan9353 

        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.

         

    • jimmytan9353's avatar
      jimmytan9353
      Copper Contributor
      Mar 18, 2024

      Detlef_Lewin 

       

      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 :cool:

       

       

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Mar 18, 2024

        jimmytan9353 

        Since Excel 2016 PQ is a part of Excel.

        Most things can be done via the UI.

Resources