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

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".

Try:

With:
The list of ingredients in Sheet2 A1:F6 and in that table any cells that do
not have an ingredients entered has the formula =""

The Combobox list in K1:K6

The Combobox link cell J1

in cell B2 the formula:

=INDEX(K1:K6,J1)

In B3 "Ingredients" (without the quotes)

and in B4 the formula:

=HLOOKUP($B$2,Sheet2!$A$1:$F$6,ROW()-ROW($B$2),FALSE)

copied down to B8

Adjust to suit your needs.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Paul" wrote in message
...
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