Talmeida13
New Member
- Joined
- Oct 2, 2020
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
Hi,
I am trying to determine commission %'s among 3 different group of products. Each group has a different rate of commission % based on their Gross Margin %.
I have 3 arrays with the different GM%'s and the commission values and i cannot seem to get this to work.
Here is the formula:
=IF(K2="Prod A",VLOOKUP(S2,Chart!$E$1:$F$7,2,TRUE),IF(K2="Prod B",VLOOKUP(S2,Chart!$I$1:$J$7,2,TRUE),IF(K2="Prod C",VLOOKUP(S2,Chart!$N$1:$N$7,2,TRUE))))
This formula works for one product group and returns the correct value, however when i add the rest of the groups it fails.
=IF(K2="Prod A",VLOOKUP(S2,Chart!$E$1:$F$7,2,TRUE)
Any help would be great.
Thanks.
I am trying to determine commission %'s among 3 different group of products. Each group has a different rate of commission % based on their Gross Margin %.
I have 3 arrays with the different GM%'s and the commission values and i cannot seem to get this to work.
Here is the formula:
=IF(K2="Prod A",VLOOKUP(S2,Chart!$E$1:$F$7,2,TRUE),IF(K2="Prod B",VLOOKUP(S2,Chart!$I$1:$J$7,2,TRUE),IF(K2="Prod C",VLOOKUP(S2,Chart!$N$1:$N$7,2,TRUE))))
This formula works for one product group and returns the correct value, however when i add the rest of the groups it fails.
=IF(K2="Prod A",VLOOKUP(S2,Chart!$E$1:$F$7,2,TRUE)
Any help would be great.
Thanks.