Forum Discussion
DP_Wood
Oct 03, 2022Copper Contributor
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 w...
flexyourdata
Oct 03, 2022Iron Contributor
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))