I'm creating a register in Excel to number engineering documents. Each document will have a unique number and will follow this numbering structure:

Discipline Code - Document Type - Sequential Number

Example: ELE-DRW-0001. This is the 1st electrical drawing in the register.

I'm trying to find the formula that will assign the next sequential number to new documents depending on their discipline code and document type code.

Example: If I am registering a new electrical drawing, I'd like Excel to give it 0002 as the sequential number.