Lookup patient information

You need a "Database" of the details, so in the Database sheet there is a list of patients, their sugar levels and the variances.

In D6 of the Review sheet you use Data Validation and link it to the patient list in the Database sheet.

In D8 you then enter this formula:

=IF(D6="","",INDEX(DATABASE!B1:B41,MATCH(D6,DATABASE!A1:A41,0)))

(IF there is no patient name, there is no date. If there is a patient name, look in Col B of the Database for the row with the name in Col A that you selected in D6 of the Review sheet.)

D10 and D12 have the same formula, but changing the column on the Database from Col B to Col C and Col D.

If you select a different patient in the DropList, the other details will change to match.

Hope this helps

Ochimus