Hi All, i am new in this group, and looks like you have perfect
knowledge in Excel.

Now, i have to recocile between two systems, first one will send
generate a payment batch lets call this system (A), and the other one
will recieve this batch and process it, let call this one (B), my role
is to reconcile and check if system (B) didn't process the amounts sent
by system (A), usually i get a copy of the LOG from sys (A) + sys (B)
and import them into excel and do the job as the following:

(A) (B)
1) Sami 1,0000 Sami 1,0000
2) John 1,500 John 1,500
3) Sara 1,000 Sara 1,000

In my case i always use VLOOKUP (B1,A1:A3,FALSE,1), but sometimes it
wont work specially when i reconcile between 2000 accounts and some of
the records in colume (B) is are missing becuase it got dropped somehow
while the batch sent in the begining from sys (A) -- sys (B) and that
result #/N/A in all the accounts after the missing record!

is there a way that excel can generate #N/A on that particular missing
record ONLY or can we use other formula to do that. Really appreciate
your help :)