This is a bit of a complicated one, or at least it feels complicated.

I am working to develop some salary grades based on the number of points roles have scored during job evaluation, for example:
Grade A = 1 - 100 points
Grade B = 101 - 200 points
etc.

What I'd like to be able to do is, as I experiment, have it so I can just adjust the number of points a grade spans so it automatically updates what grade a particular role is on. I tried using an IF function, but it didn't work as I'd hoped and also there are more than 7 grades so I don't think I could programme them all.

Excel Help suggested using v-lookup and, whilst I am familar with this function, I don't know how I'd use it in this capacity.

Any suggestions, ideas or help would be greatly appreciated, but I realise I may be trying the impossible.

Thanks