Does anyone know what formula I enter to perform the following function?

If a cell in a row contains an entry such as "R1 Live" and a second cell in
a row contains one of a range of dates in the form of 12/2010 , then the cell
result = date in the column of "R1 Live".
--
thanks