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 | ||||||
