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 ...

Formulas & Functions

Requests

Sergio Gonçalves

Copper Contributor

May 23, 2017

Thanks so much Jan. Works like a charm. Don't quite understand how, but it does.

Thanks

JKPieterse

Silver Contributor

May 24, 2017

The VLOOKUP function looks up a value in a list of values.

The last argument of the function is really important. If you set that to TRUE (as in our example) VLOOKUP *only* allows lookups in a (ascending) sorted list and if it does not find an exact match, it returns the item that is the first one less than the value you are looking for. So look for 9 and it will return the item belonging to 0. Look for 999 and it'll return what belongs to 200.

If however you use FALSE as the final argument, VLOOKUP will only return EXACT matches and #N/A! if it does not find a match. Also, the table does not have to be sorted. FALSE is the most used argument, but in your case it is TRUE we needed.

Forum Discussion

Creating a level up system with Excel.

Resources