Recipe

P

Paul

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
 
S

Spiky

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

Sandy Mann

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top