Hi everyone !

I'm facing a puzzle for my company trying to automate some entries in drop down lists given some entries in a specific cell.
To clarify, I have a file to track my supplier invoices and allocate them to specific P&L levels ( Selling, administration,...) via a drop down list ( See Below)
Some suppliers are quite repetitive per month - I would like to automate(given allocation table) the drop down entries for these suppliers but keep the drop down list for potential new ones. Obviously, I was thinking about combining Indirect & Vlookup formula but how to keep drop down list active for new ones ?

Any ideas ?



Thanks in advance !



SUPPLIER Name P&L Account - Level 1(Drop down List) P&L Account - Level 2(Drop down list)
ABC Selling & Market Access Promotion