Search for a value in one row, and then the result is the value from another row

Im Trying to write a formula in excel that would basically say: IF you find in row15 the cell showing !, THEN copy the date value (4/6) assigned at the top of that column in Row2 to a new cell. Im no...