Forum Discussion
Creating a level up system with Excel.
Hi. I'm trying to create a point based fitness log system where with each workout you earn points and with the points earned you level up over time. My issue is what would be the best way to do ...
To get a level from a list of steps, first create a little table that looks similar to this:
| 0 | Beginner |
| 50 | Intermediate |
| 100 | Pro |
| 200 | Expert |
| 1000 | Guru |
(lets assume this is on Sheet2, range A2:B6).
Now suppose you have a # of points in cell D3, you can fetch the level from the table like so:
=VLOOKUP(D3,Sheet2!$A$2:$B$6,2,TRUE)
JKPieterse I tried this with my own values, so when I put 100 in the points box and 100 points is 'Expert', it shows 'Expert' in the level name box. But when I put 105 in the points box, it shows #N/A. do you know what is wrong? Screenshot attached
- Your formula shows FALSE at the end where it should show TRUE........the false flag looks for an exact match for the lookup.
- Change the FALSE to TRUE
