Forum Discussion
Finding intersection value in a table
Hello all - hope I can find some direction - I have 'sounding tables' from our ship - these are the tables that turn feet and inches of measured liquid into a gallon value. I have the tables and I would like to use drop down menus for the feet and inches and once the values are input, have the corresponding gallon value show.
| 0" | 1" | 2" | 3" | 4" | 5" | 6" | 7" | 8" | 9" | 10" | 11" | |||
| 0' | 0 | 8 | 16 | 24 | 50 | 77 | 103 | 149 | 194 | 239 | 304 | 368 | ||
| 1' | 432 | 515 | 598 | 681 | 774 | 868 | 962 | 1058 | 1153 | 1249 | 1345 | 1441 | ||
| 2' | 1536 | 1632 | 1728 | 1823 | 1919 | 2015 | 2110 | 2206 | 2302 | 23.98 | 2493 | 2589 | ||
| 3' | 2685 | 2780 | 2896 | 2972 | 3068 | 3163 | 3259 | 3355 | 3450 | 3546 | 3642 | 3738 | ||
| 4' | 3833 | 3929 | 4025 | 4120 | 4216 | 4312 | 4408 | 4503 | 4599 | 4695 | 4790 | 4886 | ||
| 5' | 4982 | 5078 | 5173 | 5269 | 5365 | 5461 | 5556 | 5652 | 5748 | 5844 | 5939 | 6035 | ||
| 6' | 6131 | 6226 | 6322 | 6418 | 6514 | 6609 | 6705 | 6801 | 6897 | 6992 | 7088 | 7184 | ||
| 7' | 7280 | 7375 | 7471 | 7567 | 7663 | 7758 | 7854 | 7950 | 8046 | 8141 | 8237 | 8333 | ||
| 8' | 8429 | 8524 | 8620 | 8716 | 8812 | 8908 | 9003 | 9099 | 9195 | 9291 | 9386 | 9482 | ||
| 9' | 9578 | 9674 | 9769 | 9865 | 9961 | 100057 | 10153 | 10248 | 10344 | 10440 | 10536 | 10631 | ||
| 10' | 10727 | 10823 | 10919 | 11015 | 11110 | 11206 | 11302 | 11398 | 11494 | 11589 | 11685 | 11781 | ||
| 11' | 114877 | 11972 | ||||||||||||
| Input | ||||||||||||||
| example | 5' | 5" | 5461 |
1 Reply
You can use INDEX/MATCH for this. Suppose your data are:
Something like this should work as shown in cell K16:
=INDEX($C$3:$N$14,MATCH($I$16,$B$3:$B$14,0),MATCH($J$16,$C$2:$N$2,0))
