Simple VBA Excel Help

[icguser]

Hi, I have multiple columns of data - one of dates (column A), with data to the right (b-AA). How do I write the macro for "if, in a specific column, a number is greater than or less than a chosen value=>return the corresponding date (in a column to the left of the array)"

 

[JLGWhiz]

Dim myValue, myDate
myValue = Range("A1").Value
If Range("F20") <> myValue Then
	myDate = Range("F20").Offset(0, -5).Value
End If