On sheet Glucose Factor you have a Defined Table Table4, which expands automatically whenever you add new rows to this table. You also have defined a Named Range ClucoseFactor='Glucose Factor'!$A$2:$B$29, which defines a range of table on sheet Glucose factor from rows 2:29. This named range is fixed one - remains same when you add new glucose factor values. In your formula, you refer to this fixed range! Replace it with reference to Defined Table instead (like p45cal adviced)!
And you have more than one copy of Named Ranges there - with scope 'Workbook', and with scope 'Prt Date Rng'. A possible explanation is, you created the sheet 'Prt Date Rng' coping some other sheet where those named ranges were used in formulas (or did some other copy-paste operation which had this effect). Probably you have to delete all Named Ranges with worksheet scope (Except the ones used to define Print Areas) to avoid some problems in future (I suspect when the scope is a worksheet, you can refer to this range from this worksheet only, and as both copies of range have same name, it is up to Excel to decide, which one is referred to!).