Hello,
A rather simple problem I'm looking for a solution with.
I'm making some spreadsheets for online gaming, and basically, x amount of exp = x level. What i want to do is, have the amount of exp I have written down, and extract from a table what level I would be with that amount. Normally I wouldn't have an issue, except for the fact that i need to be able to search within a range.
The example I have provided I have exp listed as "50". In the column next to it, I want to be able to automatically assign the level I'd be, using the chart to the right. Anywhere between 20 and 79 exp would be level 2, so I would want it to extract the level "2" from the chart using a range.
Hopefully I explained this clear enough lol.
Bookmarks