Hello,
I have a list that contains sales data that I download from SAP. It’s just like what’s posted except the actual list is much longer. The list is in numerical order as well. I can get VLOOKUP to find the Area number and rep name but I also want to get (separately) the product category 1,2,3 & Misc $ totals as well. I am stumped on what to use with VLOOKUP (MATCH?) to get these $ totals. Perhaps VLOOKUP isn’t the right function to use either. Any Ideas ?
Thanks in Advance.
C.R.
I have a list that contains sales data that I download from SAP. It’s just like what’s posted except the actual list is much longer. The list is in numerical order as well. I can get VLOOKUP to find the Area number and rep name but I also want to get (separately) the product category 1,2,3 & Misc $ totals as well. I am stumped on what to use with VLOOKUP (MATCH?) to get these $ totals. Perhaps VLOOKUP isn’t the right function to use either. Any Ideas ?
Thanks in Advance.
C.R.
MrExcel.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Area#/Name | Category | (USD) | |||
2 | ||||||
3 | 01Smith | |||||
4 | ||||||
5 | Cat1 | 144878 | ||||
6 | Cat2 | 7042 | ||||
7 | Cat3 | 11364 | ||||
8 | 0 | |||||
9 | Sub | 0 | ||||
10 | total | 163284 | ||||
11 | 0 | |||||
12 | Misc | 368 | ||||
13 | 0 | |||||
14 | Grand | 0 | ||||
15 | total | 163652 | ||||
16 | 0 | |||||
17 | 02Jones | 0 | ||||
18 | 0 | |||||
19 | Cat1 | 98141 | ||||
20 | Cat2 | 5546 | ||||
21 | Cat3 | 5193 | ||||
22 | 0 | |||||
23 | Sub | 0 | ||||
24 | total | 108879 | ||||
25 | 0 | |||||
26 | Misc | 1199 | ||||
27 | 0 | |||||
28 | Grand | 0 | ||||
29 | total | 110078 | ||||
Sheet1 |