I'm afraid you're not getting it right as I mentioned "Fail" is an usual supplier and you have added it in "usual supplier allocation" list which is not what I mentioned.

In "Supplier Inv" sheet, the logic would be in column E & F -> If Supplier Name is among "usual supplier allocation" list then auto compute given allocation in "usual supplier allocation" list.If not ->Then use drop down lists