what's the best way to look for a value in a number range and update another column based on that information. eg, i have a table as such; fromleft  toleft    fromright  toright   leftvalue   rightvalue  lowrange   highrange newvalue 100             116            109        115    apple       pineapple 204             240           203         241    bananna   peach    requirement:  need to fill fields lowrange , highrange and newvalue.  i need to show lowrange highrange and what the value gonna be based on that on newvalue field. as you see , left fields consists of odd range and right field consists of even range of numbers.   i need to do this for a fairly large sample size like 65k. I can use access, excel or oracle.  please suggest me if you have anyidea. thank you          Last edited: 06-Feb-21 06:37 PM