Importing formulas/code from one cell to another, to affect multiple cells.

Hi

I'm a newbie in Excel (actually been using it for several years, but only for very simple stuff).
I'm trying to put together a meal planner / nutrition calculator for my girlfriend. I want to make it smart.

The idea is to select an item i one cell, which in return will affect the following cells with the nutritional values. So far so good.
I would then like, if a given amount is entered, it calculates the values.

A food item is typed in Cell A. The following cells will Index Match a table (on a different sheet), importing calculation formulas based on the food items nutritional value (Cells C - G). If an amount is typed in Cell B (i.e. 100 grams) the following cells will then calculate the correct nutritional values.

Via an old post on this forum, i learned to make an INDEX MATCH function, so that when i type "Gulerod" or something like that, the following cells import information from the Table tab... When the table contains fixed values, this works just fine. However - i tried to make the table (the cells) with calculation formulas (i.e. =SUM(4*B3))... this means the values in the tables are 0 untill a value is typed in B3 (in this example).
... however when i do the Index Match in my main tab, only the "0"'s are imported, and no matter what value i enter in B3 in the main tab, the following cells remains with the fixed value 0.

... so my question is - is it even possible to have the Index Match function import the calculation formula from the table and have it work in the main tab as well? Or is there any other way to make this work in Excel? Basically - to have the main sheet find the relevant data to use for calculation on a different tab/sheet, and then do the actually calculations on the main tab/sheet.

If attached my attempt, if this helps clarify.Planner_example.xlsx (Food items are written in Danish - sorry, the rest should have been translated, and hopefully still give the idea i'm looking for)

Thank you all for any help.

Hi again...
... i might actually have found a solution to my problem myself. It's not very elegant - but it does seem to work. If anybody had an more elegant solution, i'd be more than happy to hear about it!

In my main tab/sheet i used these formulas (references varying to the respective cells):

=SUM(((IF($A6=""; ""; INDEX(Tabel!C:C; MATCH($A6; Tabel!$A:$A; 0))))/100)*B6)

Edit: Code language has been changed into English from Danish.

Now at least, it imports the data from the Tabel sheet to the main sheet, and let's me use those data to calculate in the main sheet.
Untill i fill in the numbers to offset the calculations, the cells does display errormessages... any way to "hide" those, so the cell just looks empty?

As i said - it's not elegant coding - so if anyone has a better solution - more elegant, easier, better... I'd be more than happy to hear about it!

I'll leave this thread open for just a little longer to see if any suggestions come in.