formula that returns text

[kdestef1]

Having trouble figuring out a formula that will return text in a cell.

I have rotating (24 months) significant events based on the month.

I want the formula to look at a set of cells to find "Jun-09" then, if it finds "Jun-09" I want it to return the statement "BD Q-Syte in lab confirmed" in an adjacent cell.

As new data is entered for the new 24 months the significant event shifts with the date.

I'm close but missing something probably pretty simple here. Can anyone help?

[oldchippy]

Hi,

I'm assuming your dates are "actual" dates (01/06/2009) but custom formatted to "mm-yy". If so then if these are in column A you could use something like this in B1 copied downwards

=IF(A1=DATE(2009,6,1),"BD Q-Syte in lab confirmed","")