Dear experts,

I have a table which column A is for account numbers of new transactions to
be input from time to time. Column E listed all existing account numbers. So,
my question is, if I input/import an account number 12345 in A2, 45678 in A3
etc. and 12345 is a new account number and 45678 is our existing account
number, then D2 will remain blank and D3 will show "Y". Is it possible? If
yes, please advise how to do it.

Thanks in advance.