Pivot table not showing correct values

Hello. I have been working on my first pivot table ( with dynamic range) and it is not showing correct values as well as values I can't figure out where it comes from. This is how my pivot table should work.... when you enter a "Food ID" found on Food List sheet into Diet Log sheet "Food ID" cell all the nutrient values for that food fill the appropriate cells in that row. Then when you refresh the pivot table found in Summary sheet, the nutrient columns fill in with appropriate values.

However, when you look at the pivot table, some of the values for a food are correct and some are not. For example, the food Water shows a value of 1 for the proteins, fibers and sugar. It should be 0. The Yogurt shows some correct values and some that are not correct. I can't figure out why.

Also, not sure what the "blank" means. Also, not sure why and where the 291s come from although the columns correspond with the incorrect values for proteins, fiber and sugar.

Any help and guidance is greatly appreciated

Thanks

Hello ORoos:

Thanks for the help and especially the pivot table lesson.