If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Recipe
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 |
#2
|
|||
|
|||
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". |
#3
|
|||
|
|||
Recipe
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 |
Thread Tools | |
Display Modes | |
|
|