I am hoping someone can help me.
I have series of bands;
4. 12-14.9 etc etc
I'd like to be able to insert a number (e.g 7) into a cell and for the adjacent cell to automatically select the band (in this case it would be 2.)
Can anyone help with a function/formula? I have seen VLOOKUP but I do not think it is right.
This should work for you, see image
Another variant, if put series in the range as
the formula could be
or, for this concrete one,