Sorting table without messing up formulas

Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
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?



System Configuration: Windows / Firefox 92.0

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi Matpi,

Could you show us how your sheet looks, to find a suitable workaround for your issue?

You can use screenshots or upload your workbook to a free filesharing site like wetransfer.com and then post back the download link (always be careful with sensitive data). In case of screenshots, also let us know which cells contain formula's and what formula's you use.

Best regards,
Trowa