Dear all,

I am trying to use LOOKUP to address values that fall within a range e.g. LOOKUP(F2,{"1000<F2<2000","2000<F2<3000","3000<F2<4000","4000<F2<5000","5000<F2<6000","6000<F2<7000"}, {1,2,3,4,5,6}). However, this formula doesn't work.

The F column contains module codes e.g. 1103, 4105, 6107, etc. If the module code starts with 1, it is a Year 1 module, if it starts with 2 it is a Year 2 module and so on an so forth. I would like the Year to be reflected in another column using LOOKUP.

Thanks for offering your suggestions