Merge two excel spreadsheets using a reference and return the notes field

[Shellie_]

Hi can you help, I have two spreadsheets that i need to merge on a daily basis. Copy below. The number field is the unique reference.
What I would like to do is find a formula that can look at the reference number in the master spreadsheet find the same reference number in the daily excel sheets and transports the 'notes' section onto the master file.

Note some of the notes sections will be blank, happy if the value returns a 0

Can anyone help me with this formula? I have fiddled with find, lookup, merge and failed, oh and my knowledge of Excel is limited.




[TABLE="width: 1322"]
<tbody>[TR]
[TD]Debtor[/TD]
[TD]Date[/TD]
[TD]Number[/TD]
[TD]Due by[/TD]
[TD]Due since[/TD]
[TD]Total[/TD]
[TD]Notes[/TD]
[/TR]
[TR]
[TD]0-TWO MAINTENANCE LIMITED[/TD]
[TD="align: right"]23/11/2017[/TD]
[TD]13400[/TD]
[TD="align: right"]23/12/2017[/TD]
[TD="align: right"]5[/TD]
[TD]£ 236.40[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]0-TWO MAINTENANCE LIMITED[/TD]
[TD="align: right"]14/12/2017[/TD]
[TD]13470[/TD]
[TD="align: right"]13/01/2018[/TD]
[TD][/TD]
[TD]£ 222.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0-TWO MAINTENANCE LIMITED[/TD]
[TD="align: right"]19/12/2017[/TD]
[TD]13490[/TD]
[TD="align: right"]18/01/2018[/TD]
[TD][/TD]
[TD]£ 300.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0-TWO MAINTENANCE LIMITED[/TD]
[TD="align: right"]21/12/2017[/TD]
[TD]13506[/TD]
[TD="align: right"]20/01/2018[/TD]
[TD][/TD]
[TD]£ 138.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACCORD HOUSING ASSOCIATION LIMITED[/TD]
[TD="align: right"]13/11/2017[/TD]
[TD]13340[/TD]
[TD="align: right"]13/12/2017[/TD]
[TD="align: right"]15[/TD]
[TD]£ 1,368.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ACCORD HOUSING ASSOCIATION LIMITED[/TD]
[TD="align: right"]18/11/2017[/TD]
[TD]13364[/TD]
[TD="align: right"]18/12/2017[/TD]
[TD="align: right"]10[/TD]
[TD]£ 390.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]