Hi the following is beyond my capability
5 seperate tabs
A drop down on each tab same cell location
Can be Tea Coffee or mix
So formula being
If any of the 5 cells have “Tea” then the result is Tea
If any of the 5 cells have “Coffee” then result Coffee
if any of the cells have a mix of Tea and Coffee makes result Mix
5 seperate tabs
A drop down on each tab same cell location
Can be Tea Coffee or mix
So formula being
If any of the 5 cells have “Tea” then the result is Tea
If any of the 5 cells have “Coffee” then result Coffee
if any of the cells have a mix of Tea and Coffee makes result Mix