Thread: Summing Vlookup for multiple accounts

Sales Example.xlsx

I am trying to use VLookup (I think that's the correct approach for this) to sort sales data.


Section A (Column A) is the Data bank I have.

Section B (Column G) shows the first part of what I am trying to do (VLookup). I want the highlighted section to match automatically.

Section C (Column P) shows ultimatly what I want. I want the Number ID duplicates' Sales shown as one Number ID.

My intentions are to have one formula do this all together. If I need to use two or three different ones that will be OK.

Any and all help will be greatly appreciated. Thank you in advance.

In F6 enter formula:

=INDEX($A$6:$A$43,MATCH(G6,$B$6:$B$43,0))

copied down.

Then create a Pivot Table from that to get final sorted/unique ID totals.

Drag Number ID to Row labels, drag Sales to Summation area.

You are welcome. If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save