Hi,

Take a look at the attachment. The blue section contains the formula to extract the people from drop-down lists above. This is a dynamic table and will update automatically if you change someone's favourite food (or just press F9 to recalculate the worksheet, I put a formula into the food selection section to randomise the foods for testing purposes). Is this the sort of thing you were after? Even if you didn't want it in a table form like this, this style can be adapted to display a single food only, where you can select that food from a drop-down box also.

Let me know. I hope this helps