I think this should be easy but can't seem to get it right

Example

A B
C D E
Column of ID Number
(Number to be entered) Name Current Date
NO 1001


1002


1003


1004


Now what I need is to be able to put number in to cell in first column and
have it place the current date in cell in column C and have the NO in column
D changed to a Yes but only if the number exist in Column I.

Thanks for any help