See Attachment



In the Q1 table, I have three fields related to the Glucose reading.
(D) Libre reading (continuous monitoring sensor)

(E) Blood reading
(F) Calibrated Glucose value


I divide the blood reading by the Libre reading to produce a calibration factor. This factor is stored in the "Glucose Factor" table by start date. This calibration factor varies from one sensor to the next. Each sensor lasts 14 days. I need to re-calibrate each new sensor after it is installed. The factor usually varies +- around 1.0. The factor for several of the previous sensors was .9x. The factor for the current reading is 1.03.



The Glucose Column contains a formula which looks up the factor in the "Glucose Factor" table and multiplies the Libre reading by that factor for the current date to produce the calibrated Glucose result.



As you can see in row 3, the formula is not producing the proper result. The calibrated Glucose reading should be near 220 (219 in this case). However the formula is producing a result for a factor of .95. This is the same factor for row 29 in the Glucose Factor table beginning on 21 Jul 2023.



For some reason, the VLookup function is no longer returning the correct value. It has been working for over a year. Is there a limit to the number of rows that can be in the Glucose Factor table? What has happened between Jul and Sep?


FYI: Row 2 is hidden to preserve formatting when I insert new rows at the top.

Attached Files

Diabetes Manager.zip (873.7 KB, 6 views)