Replacing Nested IFS with LOOKUP

[MorranJuke]

Dear All,

I have an issue.
I have a table that contain salesmen, selling channel, and their achievement. I'd like to fill the incentive column using formula but I don't want to use nested If. I'd like to use lookup table instead. Here is my incentive table

Name	Channel	% Ach.	Incentive
Roxy	Medical	70%
Sam	Consumer	89%
Nana	Medical	50%
Dunn	Consumer	40%

Here is my lookup table:

Channel	Minimum %Ach.	Incentive
Medical	65%	$40
Consumer	50%	$40

Is there any easy way to solve this issue instead of using nested if? Please kindly help me. Thank you.

Best Regards,
Morran

 

[bebo021999]

Just LOOKUP is enough
Working with 1st row, Roxy. Because I dont know what range/ table address are, let call "Channel" is her chanel, "% Ach" is her achivement.
Her incentive should be:

=LOOKUP(2,1/(LOOKUP_table_column_1="Channel")/(LOOKUP_table_column_2<="% Ach"),LOOKUP_table_column_3)

 

[MorranJuke]

Just LOOKUP is enough
Working with 1st row, Roxy. Because I dont know what range/ table address are, let call "Channel" is her chanel, "% Ach" is her achivement.
Her incentive should be:

=LOOKUP(2,1/(LOOKUP_table_column_1="Channel")/(LOOKUP_table_column_2<="% Ach"),LOOKUP_table_column_3)

Thanks @bebo021999 ! Would you mind to tell me what is "2" in the Lookup function means?

 

[MorranJuke]

How about this one? Please kindly find my image below. Please let me know your thought about this problem. Thanks @bebo021999

 

[bebo021999]

What would you expect for, i.e, cell G3 and G5? and why?