Hmm...not really grouping the values of apple
I actually have to first select the apples, then user can choose one from the results (i.e. choose from 234, 534, 834). Excel will need to use the selected result (let's say 534) to do further calculations.
I know how to do the selection part...