Forum Discussion
Pulling together multiple data points after consolidating
I'm having an issue with consolidation in excel and looking for help. In this example I have four customers that have made multiple purchases each. I used the consolidate function to understand pur...
mocojo I assume you used SUMIF in column G. For columns H and I you need to use a lookup function. Depending on your Excel version that may be VLOOKUP, INDEX together with MATCH or XLOOKUP.
Though, it may be wiser to create one table with the customer information (Name, Email and Company) and another table with all transactions (Name and Purchase). Then you don't have to duplicate all customer info for every transaction.