Hi everyone!
So I have this formula which compares if ingredients are good matches.
I made everything bacon for the sake of testing but this is obviously not a great way to make an icecream cake haha
The idea is that my formula should compare every ingredients of the planification (table on the left) with each other and find if the intersecting cell of the aroma combination (table on the right) contains "G". If it does, then it has to count the cell by adding +1.
My current formula only works for one cell at a time. Any idea on how to make it more versatile so that I can quickly use it for all the other cells ?
Any help will be greatly appreciated!
So I have this formula which compares if ingredients are good matches.
I made everything bacon for the sake of testing but this is obviously not a great way to make an icecream cake haha
The idea is that my formula should compare every ingredients of the planification (table on the left) with each other and find if the intersecting cell of the aroma combination (table on the right) contains "G". If it does, then it has to count the cell by adding +1.
My current formula only works for one cell at a time. Any idea on how to make it more versatile so that I can quickly use it for all the other cells ?
Any help will be greatly appreciated!