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