Excel - Select Case with multiple criteria
<p>The code below is sort of an excerpt of my full Sub just because it'll be easier to read here. I need to add more criteria to some of the cases, and I'm not sure how to implement that.</p>

<p>To sum up what this is doing, in a row, if column K has a word that begins with B, M, or D, it runs a set of cases. If column K has a word that begins with an A, it runs a different set of cases. Again, this is working. But in some of these cases, I need it to have more criteria instead of only looking at column O.</p>

<p>For example, in the first case, it needs to check for "University of Illinois" and "UofI," but it also needs to check column P for the values of "Urbana" and "Chicago." How can I do that?</p>

<pre><code>Sub Test4()
    Dim LastRow As Long
    Dim i As Long
    LastRow = Range("O" &amp; Rows.Count).End(xlUp).Row
    For i = 84 To LastRow
        If Range("K" &amp; i) Like "B*" Or Range("K" &amp; i) Like "M*" Or Range("K" &amp; i) Like "D*" Then
            Select Case Range("O" &amp; i)
                Case "University of Illinois", "UofI"
                    Range("N" &amp; i) = "1234"
            End Select
        End If
        If Range("K" &amp; i) Like "A*" Then
            Select Case Range("O" &amp; i)
                Case "New York University", "NYU"
                    Range("N" &amp; i) = "5075"
            End Select
        End If
    Next i
End Sub
</code></pre>