| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup/match 2 critera
Hello, I need to lookup a value based on two different criteria. For example:
Matrix - Starting in A1 New Contract 1 4 7 10 Sls Perf New Contract Performance 150% 20% ..... 150% 125% 10% ..... 125% 100% 5% ..... 100% 80% 0% ..... 80% So, if an associate got 10 new contracts for the month and attained 125% of quota, he will get 125% of this component of his incentive target. THANK YOU!!!! -- Texas Wannano |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sumif formula with multiple critera | Excel Worksheet Functions | |||
| SUMPRODUCT multiple critera from different worksheets | Excel Worksheet Functions | |||
| Average only with specific critera | Excel Discussion (Misc queries) | |||
| Extract data based on critera from three columns | Excel Discussion (Misc queries) | |||
| how do i copy rows using critera in a formula? | Excel Worksheet Functions | |||
Threaded Mode
