put a cell value into a cell when the range of cell contain a specfic text

Hi All,


How do i put a cell value into a cell when the range of cell contain a specfic text using formula.
For example, in the sample below, i want to put the cell value (13/2/2014) into B3 when a range of cell contain (A) Sam.


sample.xlsx


Is it possible as well that i can copy the cell value (13/2/2014) to all fields in column B till it reaches TOM (A1) for example?

Please enlighten me.
Thanks

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

try this, copied down...
=IF(ISNUMBER(A5),A5,B4)