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

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

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