Aug-06-2017, 09:44 PM
well, with lookup value between 1180 and 1183 the value you will get is 1138, i.e. that's closest value from the list , not exceeding the lookup value.
i.e. lookup is the number you compare with the list looking for value from the list that is closest but not exceeding the lookup value (as per your original post)
i.e. lookup is the number you compare with the list looking for value from the list that is closest but not exceeding the lookup value (as per your original post)