Multiple condition and index matching

**atanu021** · 06-20-2016, 02:40 AM

Unable to solve the problem. Have to calculate the commission for respective sales representative. Condition "year of tenure" and "sales figure".
PFA

**shukla.ankur281190** · 06-20-2016, 02:43 AM

Try

D2=VLOOKUP(C2,IF(B2>3,$I$3:$J$8,$F$3:$G$9),2,TRUE)*C2

**Lemice** · 06-20-2016, 02:45 AM

Hello atanu021,

Welcome to the forum

In D2, try this formula

Please Login or Register  to view this content.

Drag down to D12. Is this what you wanted?

**JohnTopley** · 06-20-2016, 02:47 AM

Try

=IF($B2<3,VLOOKUP($C2,$F$3:$G$9,2,1)*$C2,VLOOKUP($C2,$I$3:$J$9,2,1)*$C2)

**atanu021** · 04-13-2017, 07:23 AM

Thanks a lot Ankur. It's working

**atanu021** · 04-13-2017, 07:23 AM

Thanks a lot John. It's working

**Tony Valko** · 04-13-2017, 08:51 AM

Originally Posted by JohnTopley

Try

=IF($B2<3,VLOOKUP($C2,$F$3:$G$9,2,1)*$C2,VLOOKUP($C2,$I$3:$J$9,2,1)*$C2)

A few keystrokes shorter...

=VLOOKUP($C2,IF($B2<3,$F$3:$G$9,$I$3:$J$9),2,1)*$C2

**atanu021** · 04-13-2017, 10:07 AM

Thank u John for the solution.

Re: Multiple condition and index matching