Hi

I am using Vlookup formula refering to a 2 column table of which the left is
a code and the right colmn is the amount. if the code is not found I want it
to come up zero rather than N/A, so if the table is updated in future with
different codes it will still come up correctly. Maybe it can highlight the
cell a different colour if it cannot find that code in the table?