Lookup with Index

Hi, need help on this one.

Sample table attached.

Condition:

- On the Blue Cell, it needs to Lookup the value (73.54%) in the ranges (table in the left side) and considering the LVL, Tenure as another Criteria.

Thanks a lot.

Try:

=LOOKUP(2,1/(($A$2:$A$61=K6)*($B$2:$B$61=M6)*($C$2:$C$61="Sales %")*($E$2:$E$61<=N6)),$D$2:$D$61)

copied down

Got about the same, but MUST be confirmed with Ctrl+Shift+Enter. In O6 and down:

=LOOKUP(N6, IF(($A$1:$A$61=$K6)*($B$1:$B$61=$M6)*($C$1:$C$61=N$5), $E$1:$E$61), $D$1:$D$61)

Copy to Q6 and down.

Only if it is directly related... otherwise please post a new thread.