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