Hi all,
I put together a worksheet with data from a number of patients. I am trying to figure out how to create a look up type option that when i put a patient name in, the spreadsheet will automatically provide me with data for that patient such as average sugar level, variance in blood sugar level etc. I have spent literally hours trying to figure it out with VLOOKUP, HLOOKUP, INDEX etc and just cant crack it. Obviously I am a beginner but if any of you could help I would really appreciate it!
Thanks in advance,
D.
Bookmarks