Multiple vlookup in excel

January 14, 2011 at 07:20:38
Specs: Windows XP

I have a Table that contains 3 columns; Salesman ID, Product ID, and Quantity Sold. I import this data from another source into my excel worksheet into cell A1. This information is imported daily, changes daily, but always is in sequential order for columns SalesmanID and ProductID. I need to calculate the totals for each Salesman and each Product.


SalesTable
SalesID ProductID Quantity Sold
7 22 0.08
7 25 0.21
8 20 0.17
8 24 2.00
8 25 2.21
8 29 0.08
44 20 6.00
44 22 1.00
44 24 13.00
44 25 2.00
44 29 1.00


I need to calculate the totals for each Salesman and each Product as show here.

Results
SalesmanID (20) Product a (22) Product B (24) Product C (25) Product D TOTALS
7
8
36
44
TOTALS


See More: Multiple vlookup in excel

Report •


#1
January 16, 2011 at 19:39:02

Please read the How To referenced in my signature line and then repost your data in table format.

It's a little difficult for us to tell what data is in what column.

Make sure you include Column Letters and Row Numbers so we can reference the correct cell if we have further questions.

Thanks!
DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 17, 2011 at 06:13:24

I need to take this DATATABLE and lookup the Sales Rep ID, then the Product ID, then the Quanity and transfer it to an other table that summarizes the results. All SalesReps sell all of the products. The DATATABLE will be updated daily and the SalesRep may have not sell of the available products everyday.

DATATABLE
1 A B C
2 SalesRep ID Product ID Quantity
3 7 20 3
4 7 592 1
5 8 20 2
6 8 22 4
7 8 24 1
8 8 1316 2
9 44 20 5
10 44 22 4
11 44 24 2
12 44 29 1

OUTPUT
SalesRep )
E F G H I J K L
2 SalesRep ProductID (Quantity Sold)
3 20 22 24 25 29 592 1316
4
5 7 14 3 - 6 8 13 -
6 8 1 5 7 17
7 44 6 12 1 22

/pre>


Report •

#3
January 17, 2011 at 06:17:19

Derby,
I couldn't figure out how to post the worksheet showing the columns and row headers. I do have a picture of the worksheet. Can I somehow post that image?

Report •

Related Solutions


Ask Question