D
Dan Wilson
Good day. I am using Excel 2002 and have developed quite
a few workbooks to analyze my business. I need some help
now with creating formulas using parameters created within
the worksheet.
Background: There are several workbooks containing recipes
for products that I manufacture. Each of the workbooks
contains data defining the cost of making that product as
well as the cost of the product broken down into
categories such as gallons and ounces. These costs are
always in the same cells in each workbook. For example,
cells G7 through G10 will contain this data.
Problem: There is a workbook containing a list of all the
various products listed by flavor. The nature of the
business is such that the flavor list is constantly in
change. New products get added, unpopular ones get
deleted. One of the purposes of the flavor list is also
to combine the costs created in cells G7 through G10 of
the individual recipe workbooks into the flavor list
workbook to show all of the costs in one place and be able
to do analyses on those costs. Since the flavor list is
in constant change, I want to be able to have the flavor
list access cells G7 through G10 of new flavors without
having to manually modify the workbook.
The flavor list workbook will be set up to allow new
flavors to be added at the end of the list and then let
the list be resorted alphabetically by flavor name.
Example:
Vanilla workbook G7 thru G10 = costs
Chocolate workbook G7 thru G10 = costs
Flavor workbook
A5 B5 C5 D5 E5 F5
folder filename G7 folderfilenameG7 VLOOKUP results
In the above example, A5 will contain the folder for all
of the recipe workbooks, B5 will contain the filename of
the recipe. C5 will be the target cell in the recipe. D5
will then be the result of concatenating A5, B5 and C5.
So far, this all works. The problem is E5. I want to be
able to use the VLOOKUP feature and somehow have the
results in D5 embedded or referenced into the VLOOKUP
formula without having to manually modify it each time a
new flavor is added to the list. F5 would then be the
results of the VLOOKUP.
Is this possible? If more details are needed, please
reply. I will also respond to any inquiries on my email
at (e-mail address removed). Thank you in advance for any
reponse. This newsgroup has always come through for me.
a few workbooks to analyze my business. I need some help
now with creating formulas using parameters created within
the worksheet.
Background: There are several workbooks containing recipes
for products that I manufacture. Each of the workbooks
contains data defining the cost of making that product as
well as the cost of the product broken down into
categories such as gallons and ounces. These costs are
always in the same cells in each workbook. For example,
cells G7 through G10 will contain this data.
Problem: There is a workbook containing a list of all the
various products listed by flavor. The nature of the
business is such that the flavor list is constantly in
change. New products get added, unpopular ones get
deleted. One of the purposes of the flavor list is also
to combine the costs created in cells G7 through G10 of
the individual recipe workbooks into the flavor list
workbook to show all of the costs in one place and be able
to do analyses on those costs. Since the flavor list is
in constant change, I want to be able to have the flavor
list access cells G7 through G10 of new flavors without
having to manually modify the workbook.
The flavor list workbook will be set up to allow new
flavors to be added at the end of the list and then let
the list be resorted alphabetically by flavor name.
Example:
Vanilla workbook G7 thru G10 = costs
Chocolate workbook G7 thru G10 = costs
Flavor workbook
A5 B5 C5 D5 E5 F5
folder filename G7 folderfilenameG7 VLOOKUP results
In the above example, A5 will contain the folder for all
of the recipe workbooks, B5 will contain the filename of
the recipe. C5 will be the target cell in the recipe. D5
will then be the result of concatenating A5, B5 and C5.
So far, this all works. The problem is E5. I want to be
able to use the VLOOKUP feature and somehow have the
results in D5 embedded or referenced into the VLOOKUP
formula without having to manually modify it each time a
new flavor is added to the list. F5 would then be the
results of the VLOOKUP.
Is this possible? If more details are needed, please
reply. I will also respond to any inquiries on my email
at (e-mail address removed). Thank you in advance for any
reponse. This newsgroup has always come through for me.