Thread: Recipe
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Recipe

On Sep 25, 7:06 am, "Paul" wrote:
Hi,
Is there any way that the user could choose an item from a combo box, and
somewhere on the sheet the recipe for that item to be shown?
i.e. choose BREAD, and somewhere on the same sheet the ingredients for it to
be listed : flour, water, yeast, etc. The list of the products and
ingredients is on a different worksheet.
Thanks


What does the list look like? It should be easy to reference the
combobox's cell and do a lookup on the "Bread".