find data from other sheet
 

Sunflower

Hello,
I entered in a workbook 5 sheets containing 5 different recipes in each sheet. each sheet contained, in column a; the weight of ingredient,
and in column b the name/description of the ingredient. in the last sheet (6) I listed, in
column a, all ingredients used in all recipes (sheets), and in column b I want to have a formula which will return how much (sum) of that
ingredient I will need based on a table in sheet 6 where I can select
(via drop down list) which and/or how many recipes (sheets) I am selecting.

Thanks in advance,

Jay

Hi!

Glad to see you turned off your caps lock!

Would need to see the file. If you want to send me a copy
I'll see what I can do. Post back with a good email
address and I'll contact you.

Biff

-----Original Message-----
Sunflower

Hello,
I entered in a workbook 5 sheets containing 5 different
recipes in each sheet. each sheet contained, in column a;
the weight of ingredient,
and in column b the name/description of the ingredient.
in the last sheet (6) I listed, in
column a, all ingredients used in all recipes (sheets),
and in column b I want to have a formula which will return
how much (sum) of that
ingredient I will need based on a table in sheet 6 where
I can select
(via drop down list) which and/or how many recipes
(sheets) I am selecting.

Thanks in advance,

Jay