I am looking to find out if a specific value falls in a range of values on a separate sheet and return a value. For example: Sheet 1 A B C 1 0 10 Low 2 11 30 Med 3 31 50 High Where A is the lower value in a range, B is the upper value in a range and C is the value of anything falling in that range. Sheet 2 A B 1 7 Low 2 38 High 3 15 Med Where A is the value used to look up and B is returned from Sheet 1 I am not sure if Lookup or Indexing will work, I am thinking it will need some VBA, but not sure. Sincerely, albay

Post this in the Office Software forum here: http://www.computing.net/forum/offi... Home Page http://ewen.uuuq.com/