Day 2: Match transactions with XLOOKUP

What you will be able to do

Look each cash-book line up in the bank's list by reference, label what is missing, and read the result in both directions.

The books say what you recorded and the bank says what happened. Matching them line by line by eye is slow and easy to get wrong. A lookup on the reference does it in a moment, and its fourth argument is where a missing match gets a plain name instead of an error. Yesterday's clean references are what make this work.

Step 1 of 8 · 1 point

Row 2 holds PMT-2201. In K2, look its clean reference up in the bank's list and return the bank's amount, or Not on bank when there is no match, so it can be filled down column K.