I have created a dynamic unit conversion Data Table, example below, and want to find specific values basically using an intersection type search. gpm_us is the reference unit, in this example, where all other units are converted based on it. For example, let's say I want the "Min" converted value of m3/hr which would give me 1.14. As mentioned, the data table will be dynamic and now I need to be able to pull conversions from the table as needed. Thanks in advanced for you help!!
Units | Min | Norm | Max |
gpm_us | 5 | 15 | 30 |
l/min | 18.93 | 56.78 | 113.56 |
m3/hr | 1.14 | 3.41 | 6.81 |
bbl/day | 171.43 | 514.29 | 1028.57 |
bbl/hr | 7.14 | 21.43 | 42.86 |