Hi JulieD,

You can use the VLOOKUP function in Excel to look up a value between two numbers and return a related value. Here's how you can do it:

1. First, make sure that your table in Sheet2 is sorted in ascending order by the LOW column. This is important for the VLOOKUP function to work correctly.
   
2. In the cell where you want to display the code (let's say it's cell A1), enter the following formula:
   
   
   Formula:

   =VLOOKUP(B1,Sheet2!$B$2:$C$4,1,TRUE) 

   Here, B1 is the cell where you have the number 27.568, Sheet2!$B$2:$C$4 is the range of your table (excluding the header row), 1 is the column number of the CODE column in your table, and TRUE specifies that you want an approximate match.
   
3. Press Enter to apply the formula. The formula should return the value "C", which is the code associated with the range that includes 27.568.
   
   If the value you're looking up matches either a LOW or HIGH value in your table, the formula will return the corresponding CODE value. For example, if you were looking up the value 26.358, the formula would return "A".