(Nigel gave me some great advice about using a data sort
solution to my question below, but it still requires a lot
of manual comparing of list to list. Is there any way to
automate this and have the computer do it??)


Hello out there!

Here's my goal. Whether tis possible remains an open
question. I have two lists, (each list can be on a
separate excel worksheet or separate file) one with
account numbers and amounts, sorted in order by the
mainframe. Same with the other list. What I would like
to do is compare the lists, update list A with List B
numbers or zero them out if they appear on list A but have
no amounts in list B.

List A List B

Fund Acct# Amount Fund Org # Amount
100 22001 $20.02 100 22001 $30.10
100 22002 30.00 100 22002 $40.24
200 24003 60.00 200 24001 31.00

So in row 2, the figure of $20.02 would be replaced by
$30.10, same situation in row 3, row 4 account 24003
should be zero because it has no value in the current list
B, and List A should be updated to insert a new account
24001 and the amount of $31.O0. I tried nested if
statements, but it was an entirely manual solution. I am
trying to automate. Any help would be great!


...