I’m wondering, @Francois1, if you shouldn’t be looking at this differently. I’m thinking that this is a many-many relationship.
One recipe can have many ingredients, and one ingredient can be used in many recipes.
Then, just thinking off the top of my head, have three sheets.
- Recipe detail
- Ingredients in recipe
- Ingredients lookup (i.e. list of all ingredients ever.)
I think then you should be able to create the ingredients as a checklist.
As I say, this is off the top of my head, so not certain it will work. But it might be worth pondering.