I have two sheets containing unordered serial numbers. In fact it is a bank
reconciliation, one list is generated by the bank containing cheque numbers
in full and not by cheque order but by value date, another sheet contains all
cheques issued, but cheque number have had to be truncated because of
limitation in size of field; the last four numbers are commonly used.

I have to bring the date from the bank statement (sheet2) to a blank colum
in (Sheet1) the list of outstanding cheques.

Can anyone give me a lead as how to go about.

Thks for your usual support