Cell C5 uses DATA VALIDATION to select from a list.

Cell AO5 uses vlookup to come up with a number based on the selection in cell C5 (so if the user selects the first item in the list in cell C5 then the result in AO5 is 1...if the user selects the 4th item in the list the result in AO5 is 4)

If a user selects ANYTHING but number 4 in the list in cell C5, I want the data in cell H5 to be cleared.

There is already a private sub running on this sheet and I need to add to it. Here's what the existing looks like:

Private Sub Worksheet_Change(ByVal Target As Range)  


Dim Changed As Range
    Set Changed = Intersect(Target, Range("B48:L48"))
    
    If Not Changed Is Nothing Then
    
       If UCase(Target.Offset(-1, 0).Value) = "N/A" Then
            Application.EnableEvents = False
            Target.ClearContents
            MsgBox "Roll size unavailable"
            Application.EnableEvents = True
        End If
        
    End If
    Set Changed = Intersect(Target, Range("B49:L49"))
    
    If Not Changed Is Nothing Then
    
       If UCase(Target.Offset(-2, 0).Value) = "N/A" Then
            Application.EnableEvents = False
            Target.ClearContents
            MsgBox "Roll size unavailable"
            Application.EnableEvents = True
        End If
        
    End If
    
End Sub