I need to be able to do the following, if possible:

Columns P:T have drop down validation boxes in them, if the user selects
"Cr" from the list in any of these 5 columns and the value in column B is 1
then I want "Yes" entered into column V.
Also, if the value selected is not "Cr" and column B is 1 then I would like
"No" entered in column V.

This is what I was trying, but with no luck:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 16 Or Target.Column <= 20 Then
If Target.Value = "Cr" And '(not sure how to reference column B and
target row).Value = 1 Then
'(not sure how to reference column V on target row).Value = "Yes"
ElseIf Target.Value < "Cr" And '(not sure how to reference column B and
target row).Value = 1 Then
'(not sure how to reference column V on target row).Value = "No"
End If
End If
End Sub

Many thanks in advance.

Gareth