collegeitdept
Board Regular
- Joined
- Nov 14, 2008
- Messages
- 185
I have been trying to figure out how to solve the following question:
Data:
CA AZ WA OR
452 2302 1251 236
3176 228 491 219
1552 435 451 210
3024 244 1751
The columns are States (regions), and the rows contain store location numbers in their respective region.
I have been trying to find a solution that would look-up in the range a store number/value (ie: 435) and return the the Region it is located in (ie: "AZ").
Does any one know how to solve this problem?
Thanks.
Data:
CA AZ WA OR
452 2302 1251 236
3176 228 491 219
1552 435 451 210
3024 244 1751
The columns are States (regions), and the rows contain store location numbers in their respective region.
I have been trying to find a solution that would look-up in the range a store number/value (ie: 435) and return the the Region it is located in (ie: "AZ").
Does any one know how to solve this problem?
Thanks.