Hi

Place this formula in D2:

=IF(ISERROR(LOOKUP(A2;$E$1:$E$2));"";"Y")

Change range $E$1:$E$2 in the formula to refere to the list of existing
account numbers, then copy the formula down to the range needed.

Regards,

Per
"Freshman" skrev i meddelelsen
...
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.