I have the following table that reminds us of when changes need to be made:
Agency Added Tie 7-9 Tie 10 - 12 Convert
ATT Apr-05 Sep-05 Dec-05 Mar-05
ANC Oct-05 Mar-05 Jun-05 Sep-06

I'd like to set up a MsgBox that says something to the effect of
If G17 = Sep-05 then "Tie 7-9" for "ATT".
If G17 = Jun-05 then "Tie 10-12" for "ANC"

How can I tell VBA to compare the date in G17 and give me the Column and Row
headings so I know which changes are due this month?