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