Hello again,
I have a list similar to what is posted, but much bigger. I currently use 2 VLOOKUPS, one each for the East territories and the West territories to get each reps respective sales $. My list is about to grow again with North and South territories, and again, it's not in any given order other than East, West, North & South. I'm trying to find one formula that will give me sales $ for each rep without sorting the list first. Any ideas will be much appreciated.
Thanks in advance,
C.R.
I have a list similar to what is posted, but much bigger. I currently use 2 VLOOKUPS, one each for the East territories and the West territories to get each reps respective sales $. My list is about to grow again with North and South territories, and again, it's not in any given order other than East, West, North & South. I'm trying to find one formula that will give me sales $ for each rep without sorting the list first. Any ideas will be much appreciated.
Thanks in advance,
C.R.
MrExcel.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
44 | EastTerritories | Region | Sales | |||
45 | 01Bob | N.E. | $15,000 | |||
46 | 03Jim | S.E. | $12,000 | |||
47 | 07Susan | N.E. | $9,000 | |||
48 | 08Paul | N.E. | $17,500 | |||
49 | 10Tim | S.E. | $19,000 | |||
50 | WestTerritories | |||||
51 | 02Frank | S.W | $9,700 | |||
52 | 04Gene | W | $10,100 | |||
53 | 05Terri | W | $13,500 | |||
54 | 06Larry | S.W. | $8,400 | |||
55 | 09Kathy | S.W | $9,600 | |||
56 | 11Ned | W. | $10,700 | |||
Sheet1 |