Comparing cell to range of values, then returning a s/n

Hi, I would like to compare the ‘lookup value’ against the list of 5 values and find out the ‘first value’ that is equal to or greater than the ‘lookup value”, then lastly generate the output, the s/n with reference to the ‘first value’. 
Please refer to the example below. Any help would be greatly appreciated. 
      Lookup value
1 154.83   155.52
2 155.48    
3 155.51   Desired output 
4 156.2   4
5 160.3    

By: James Won

Leave a Reply

Your email address will not be published. Required fields are marked *