I want to evaluate more than 7 conditions in a cell where I want to give a
unique score to up to 15 variables and know I'm limited to 7 with a nested IF
function.

If, in cell B3 I wanted to lookup the values and assign a score of '1' for
value x, '2' for value x+3, '3' for variable x+17 ... etc to '15' for value
x+39 what would be the form of a Vlookup function to get these scores
correctly input?

Many thanks!