On Oct 15, 11:21*pm, Mike H wrote:
Hi,

I may be missing something here but on the assumption dates are entered
sequentially in column A don't you really want the last value in Column C
regardless of date.

Yep

if so try this

=LOOKUP(10^23,'ANZ Bank Statement'!C:C)

Now if someone has more than 10^23 dollars/pounds in the account this fails :)

It worked. Thanks. Now I'm curious about *why* that worked!?

Travis