LOOKUP() replace with formula in cell instead of value

Hello!

So I'm making an excel sheet to track what I eat. I managed to discover the LOOKUP() function and it is actually works! The problem is that the lookup function shows the value of the cell and not the formula contained in it.

Heres the excel sheet

                        AMNT  Pro   Carb  Fat
    A                    B     C      D      E
9 Chicken Breast	100   	20	0	1.5
10 Fruit		  1	25	0       0
11 whey	                  1	24	3	1
12 rice	                 43	1	34     3
	
15 rice	                 43	1	34	3

A9:E9 - A12:E12 contain the data. A15-E15 are using the LOOKUP function. I'm sure you all know how this works.

The formula I'm using in cells B15-E15:
=LOOKUP($A$15,$A$9:$A$12,$B$9:$B$12) respectively

Now the cells with values actually have formulas in them and I would like to use the lookup command (i'm not sure of any other) and somehow use the formula inside the cell instead of the value.

I hope this makes sense. As i'm sure you can see this is my first post

Thanks!