On Monday, April 9, 2012 7:25:39 AM UTC-5, Matthew Williamson wrote:
I want to use the following IF ... THEN.

If any cell in column D contains x then put y in the same row in column
G
and
If any cell in column D contains a then put b in the same row in column
H

Can this be done?




--
Matthew Williamson

Or use a worksheet_change event macro to make it automatic without any formulas. Right click sheet tabview codeinsert

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Or Target.Column < 4 Then Exit Sub
If UCase(Target) = "X" Then Target.Offset(, 3) = "Y"
If UCase(Target) = "A" Then Target.Offset(, 4) = "B"
End Sub