ehho2: what's the best way to look for a value ..

Posted by: ehho2 February 6, 2021

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