Hi guys. I have this table that I'm using to plot 3 different three criteria (size, weight, and eaten or not) for the tables on the right.
What I want to do is take the "help" cells and specify which fruit met that criteria. For instance, in cell J3, I want to change "help" to the fruit symbol "W" from B3. Especially, for cases like H5 where there are 2 different fruits that meet the small & light criteria (Kiwi and Grape) and make cell H5 read "K, G" instead of Help help".
Basically, in cell I4, the Orange met all 3 criteria (medium, average, eaten = no). Therefore, I want cell I4 to read "O". That's basically it. For all cells in those two tables on the right.
What would be more convenient if I could reference column B for all the fruit symbols. I want the same to happen for all the other fruits.
I'm not even sure =REPT() is the right way to go about this... Thank you in advance for the help.