Forum Discussion
Solved
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 c...
Let's say your partner enters a blood-glucose level in B4.
In C4:
=LOOKUP(B4, {0, 4, 7.1, 10.1, 13.9}, {"LOW", "NORMAL", "BORDERLINE", "HIGH". "DANGEROUS"})
You can copy/paste the cell with the formula to other cells.
Let's say your partner enters a blood-glucose level in B4.
In C4:
=LOOKUP(B4, {0, 4, 7.1, 10.1, 13.9}, {"LOW", "NORMAL", "BORDERLINE", "HIGH". "DANGEROUS"})
You can copy/paste the cell with the formula to other cells.
Perfect bud, thanks a lot this works perfectly!