Expand the current formula to include additional cells

Hi,

I have been handed a spreadsheet that a previous employee had created and have been asked to update it.

I am still learning Excel and I am struggling with updating it to account for the new way of working which is working off of additional data

Essentially the user enters a barcode for a container in cell B2 which is populated from another sheet in the background taken from our system, then in B3 down the user enters the barcode for a product, it then matches it to a count to advise of discrepanices or if it is not for that container.

I have added I2:K2 cells on the 100% check sheet to account for the additional info & copied the formula across, but how do I expand the formulae to include I2, J2 & K2 whenever I input a barcode that is not listed in the "Supplier SKU" field it kicks out the error message in the formula -as the same product can have up to 4 different barcodes I need to be able to account for each one as it is entered, I have attached a sample book to aid in the explanations.

Hope this is clear & thanks in advance

Demo