I have a 2 tabbed worksheet. Sheet 1 has all my recipes. Each recipe has 3 columns. Column 1 is amount, column 2 is unit of measurement and column 3 has the ingredient. I have 100 entries like that.
Sheet 2 is where I am trying to build an array that will show my which recipes contain which ingredients.
The 2 axis I have are the Recipe names (Which are the first row of each recipe on Sheet 1) and the other axis has the various ingredients.
My thought was just to use VLOOKUP to reference the ingredient and use the recipe name to define the range to look in, and that is where I am having the problem. I do not know how to dynamically define that range based on the recipe name.
Any help would be appreciated
