 <p>Try this</p> <pre><code>If Right(Field2, 3) = "A-1" Or _ Right(Field2, 3) = "A-2" Or _ Right(Field2, 3) = "B-1" Or _ Right(Field2, 3) = "B-2" Or _ Right(Field2, 3) = "C-1" Or _ Right(Field2, 3) = "C-2" Or _ Right(Field2, 3) = "D-1" Or _ Right(Field2, 3) = "D-2" Or _ Right(Field2, 3) = "D-3" Then Cells(i, 50).Value = "OtherPrtnrs /Dcrs &amp; Dept heads" End If </code></pre> <p>Or better still... this</p> <pre><code>Select Case Right(Field2, 3) Case "A-1","A-2","B-1","B-2","C-1","C-2","D-1","D-2","D-3" Cells(i, 50).Value = "OtherPrtnrs /Dcrs &amp; Dept heads" End Select </code></pre> <p><strong>Note</strong>: I am assuming that <code>i</code> is a valid row number</p> <p><strong>Explanation</strong>:</p> <p>When comparing using an <code>If</code> statement, you cannot say <code>If A = B or C</code>. You are supposed to compare is separately. <code>If A = B or A = C Then</code>. Here each <code>OR</code> is its own <code>Boolean</code> statement i.e it will be evaluated separately.</p> <p>When you have multiple such comparisons, it is better to use a Select Statement as shown in the example above.</p>