Sorting table without messing up formulas

Hello,
I'm trying to create an excel file to manage my diet and meal plan and counting macros.
I have in the same file a table filled with different kinds of food and their macros beside each one.
Then I use this table to calculate kcal and macros of what I eat using ie. =Cell1*Cell2, where cell2 contains data from the table.
The problem with this is that whenever I sort the table Cell2 doesn't contain the same data anymore and gives me a wrong result.
What could I do?