I've got a check register on one sheet....plus a listing of deposits and
other debits and credits. Rather than manually check off cleared
checks/deposits, I'd like to be able to set it up so that I can key the
checks (and their corresponding amounts) from the bank statement into columns
and have Excel, through the use of IF, AND, etc., find the check in the check
register, verify that the amounts are the same, and mark them as being
cleared. Is this possible? If so, I haven't a clue how to set it up. It
seems like there would be several layers of nesting functions. Can anyone
help me set this up?