One way:

=A2*IF(ISERR(FIND(D2,"MNOPQ")),VLOOKUP(C2,Sheet2!A :B,2,FALSE),5%)


Note: In general, it's a better use of the replyer's time to lay out the
entire problem, rather than playing bring me a rock...

In article ,
"Pete Petersen" wrote:

You ROCK!....But I like to mix things up and I have added yet another
obsticle to the equation:

I have created a SHEET2 with the way you have suggested and added the
commissions using the formula to column Commission but take a look at this
issue:

Margin Commission MRKT SEG SEG
$(15.52) $(1.21) Digital Printer A
$(45.00) $(3.51) Digital Printer A
$(15.00) $(1.17) Digital Printer A
$(15.00) $(1.17) Digital Printer A
$(30.00) $(2.34) Digital Printer C
$(83.00) $(6.47) Digital Printer C
$(276.59) $(21.55) Quick Printers C
$(58.00) $(4.52) Digital Printer C
$(51.00) $(3.97) Digital Printer C
$(39.00) $(4.56) Professional Photogr E
$(33.25) $(2.59) Digital Printer D
$(39.78) $(4.65) Professional Photogr D
$(14.00) $(1.64) Professional Photogr E
$(65.60) $(5.11) Digital Printer C
$(69.35) $(8.10) Professional Photogr D
$(29.16) $(3.41) Professional Photogr E
$(152.48) $(11.88) Digital Printer P
$(306.00) $(23.84) Digital Printer C
$(95.90) $(7.47) Digital Printer C
$(40.00) $(4.67) Professional Photog D
$(110.42) $(8.60) Exhibit House Q
$(110.42) $(8.60) Exhibit House Q
$(23.74) $(2.77) Professional Photogr C
$(99.50) $(7.75) Digital Printer B
$(29.16) $(3.41) Professional Photogr D
$(26.74) $(3.12) Professional Photogr D
$(153.00) $(11.92) Digital Printer C
$(29.16) $(3.41) Professional Photogr E
$(63.75) $(4.97) Digital Printer B
$(69.50) $(5.41) Digital Printer B
$(35.98) $(2.80) Digital Printer B
$(93.60) $(7.29) Digital Printer A


I need to keep the same thing as before only if column SEG equals either
"M", "N", "O", "P", or "Q" then they get paid an even 5% regardless of the
Market SEGMENT.

Do you have a way to do this.