| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's themost efficient way
I have sales people 1 through 5. If one of them sells something and enters
it I want to be determine which person did the biz; kinda like "if number under Prod then the person in the left cell did the biz". I'm trying to be most efficient since I have a table of 7 x 7. Prod SPerson1 SPerson2 SPerson3 $100 SPerson4 SPerson5 Once I know who did the biz, say B7 show this to be SPerson3, I can lookup their compensation based on their commission. I need to be able to VLookup(B4,"B7"&_Contract,2,false). There is a range named SPerson3_Contract, as are 1,2,4 & 5. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's themost efficient way
On Dec 30, 3:05*pm, Rod wrote:
I have sales people 1 through 5. *If one of them sells something and enters it I want to be determine which person did the biz; kinda like "if number under Prod then the person in the left cell did the biz". *I'm trying to be most efficient since I have a table of 7 x 7. * * * * * * * * Prod SPerson1 * * SPerson2 * * SPerson3 * *$100 SPerson4 SPerson5 Once I know who did the biz, say B7 show this to be SPerson3, I can lookup their compensation based on their commission. *I need to be able to VLookup(B4,"B7"&_Contract,2,false). *There is a range named SPerson3_Contract, as are 1,2,4 & 5. Thanks Try: VLookup(B4,INDIRECT(B7&"_Contract"),2,false) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's themost efficient way
Use the INDIRECT function.
=VLookup(B4,INDIRECT(B7&"_Contract"),2,false) HTH Elkar "Rod" wrote: I have sales people 1 through 5. If one of them sells something and enters it I want to be determine which person did the biz; kinda like "if number under Prod then the person in the left cell did the biz". I'm trying to be most efficient since I have a table of 7 x 7. Prod SPerson1 SPerson2 SPerson3 $100 SPerson4 SPerson5 Once I know who did the biz, say B7 show this to be SPerson3, I can lookup their compensation based on their commission. I need to be able to VLookup(B4,"B7"&_Contract,2,false). There is a range named SPerson3_Contract, as are 1,2,4 & 5. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Efficient linking | Excel Discussion (Misc queries) | |||
| IF and VLOOKUP - how efficient? | Excel Worksheet Functions | |||
| What is more efficient | Excel Discussion (Misc queries) | |||
| something more efficient that =IF, and sytax questions | Excel Discussion (Misc queries) | |||
| is there a more efficient formula than... | Excel Worksheet Functions | |||
Linear Mode
