Field names need to match exactly, you need Vendor No. in B1.

Also a good idea to unmerge rows 7 and 8.

If row 8 goes, then your formula needs to be =DAVERAGE(A7:N101,"Days Late",B1:B2)

B2 needs to contain just the vendor number as an integer.