Hello
I'm using a PC – Excel 2013
I need help with a formula.
In column Z, I have a formula that is looking at column E, if the product matches the product listed between row 38- 65, and column J 38-65, states yes, then we need to supply a 5% discount from column N.
I need a 5% discount off of the price for Print charge (column N).
I know there is a better way to complete this. Any advice would be greatly appreciated.
Please see attached example.
Thanks
Amy
Hi Amy
A VLOOKUP should solve your problem.
Try this : In cell Z10 enter =IF(VLOOKUP(E10,$E$38:$J$65,6,FALSE)="Yes",5%,0)*-N10
A more preferred way is to have the 5% entered into the row 38-65 replacing "Yes" and 0% to replace "No"
Then any changes to the discount structure will only involve changing the lookup table instead of the formulas.
Hope this helps.
Hi SunnyKow
This is great. Thank you. How would I write the formula if I changes the "yes/no" to 5% / 0%?
I would like to make easier for my coworkers to understand.
Thank you so much
Amy
Just use =VLOOKUP(E10,$E$38:$J$65,6,FALSE)*-N10
SunnyKow
This worked great. Thank you so much.
Amy
No problem 
