In column J I have dates in the format mm/dd/yy ... then across row 5 I have
monthes in the form month/yy (i.e. Apr-09). If a date in column J reads
05/16/09 , I want to place the certain text in the column corresponding with
May-09 (in the row that reads 05/16/09). Does that make sense? Any help?

I'm sure this macro will not do exactly what you want, but try it and come
back with corrections you want. Otto
Sub PlaceCertainText()
Dim rColJ As Range
Dim i As Range
Set rColJ = Range("J6", Range("J" & Rows.Count).End(xlUp))
For Each i In rColJ
Cells(i.Row, Month(i)) = "Certain text"
Next i
End Sub

"lightbulb" wrote in message
...
In column J I have dates in the format mm/dd/yy ... then across row 5 I
have
monthes in the form month/yy (i.e. Apr-09). If a date in column J reads
05/16/09 , I want to place the certain text in the column corresponding
with
May-09 (in the row that reads 05/16/09). Does that make sense? Any help?

=TEXT(J5,"MMM""-""yy")

should work

greetings from New Zealand

"lightbulb" wrote in message
...
In column J I have dates in the format mm/dd/yy ... then across row 5 I
have
monthes in the form month/yy (i.e. Apr-09). If a date in column J reads
05/16/09 , I want to place the certain text in the column corresponding
with
May-09 (in the row that reads 05/16/09). Does that make sense? Any help?