Excel VLOOKUP/IF Assistance.

Hello All,

I have a longterm partner who was recently diagnosed with Diabetes due to fluctuating Blood Glucose levels. I am currently in the process of making her an Excel spreadsheet where she can record her hourly Blood-Glucose levels, day by day to monitor her sugars.

When she records her blood glucose levels, she is given a value in mmol/L which she compares to a indicator chart, this chart tells her if the glucose level are low/normal/high/dangerous etc.

In the spreadsheet I am creating for her, I want it so that she can just type in whatever value the machine gives her into the spreadsheet, and then in a cell next to that value, display what kind of range that value lies in. I have a basic steps for this below:

1. Enter Blood-Glucose levels into cell.
2. Spreadsheet compares value in cell to values in "Indicator Sheet"
3. Excel prints whatever category that value is a part of in the next cell.

I have messed around with some VLOOKUP/IF statements but I find that this is not given the desired results for me atm. I can provide the SS I am currently working on if anyone wishes to take a look.

Any and all help is appreciated!

Kind regards,

Tom.