Take a reference value from a cell and trace it with a Column.

Hi,

Let me explain my issue

I have data in column C from cell C4 onwards. In Cell B4 i will put any value from the data of column C. In Cell D4, this value (which i put in Cell B4) should be traced from the column C and written in this cell D4.

For Example,
i put value 3 in cell B4.
3 is in cell C7 in column C.
Cell D4 should take value from B4 as reference and trace it in the Column C and write in its cell D4.
After this, in cells D5, D6, D7 ......... next values after C7 i.e C8, C9, C10....... should be filled automatically.

(sample file is attached for further clarification)

Hi @TMS,

Now i used this for date and time instead of values. It is working for this also

but

there is a issue.
from D19 to onwards 1/0/1900 0:00 this kind of date is coming. even it is not in the Column C. There should be blank cell after D18 instead of this date and time.
(File is attached for further clarification)