| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup/match 2 critera
Hi,
Maybe something like: =INDEX(A1:E6,MATCH(F1,A1:A6,0),MATCH(G1,A1:E1,0)) where F1 is the Sls Perf value and G1 is the new contract value. HTH Jean-Guy "Wannano" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup/match 2 critera
It worked. Thanks!!!
-- Texas Wannano "pinmaster" wrote: Hi, Maybe something like: =INDEX(A1:E6,MATCH(F1,A1:A6,0),MATCH(G1,A1:E1,0)) where F1 is the Sls Perf value and G1 is the new contract value. HTH Jean-Guy "Wannano" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
