Hi,
I have a list a numbers with two columns (depth and time). I also have
another depth (d1) value and I would like to use to look up the list and
find the nearest 2 depth values so I can use them to find the
correlating time value (t1) for (d1)
eg
d1 = 1200
Time Depth
0.00 0.00
223.40 -325.00
381.80 -525.00
551.00 -735.00
677.40 -925.00
842.00 -1175.00
952.20 -1373.80
970.00 -1425.00
1058.40 -1675.00
I would like to be able to look up the list using d1 and have it return
842.00 -1175.00
952.20 -1373.80
so I can use a linear equation to work out what the correlating time
for d1 is.
Can someone please help me work out which functions are the best to
use.
Thanks
--
geooil
------------------------------------------------------------------------
geooil's Profile:
http://www.excelforum.com/member.php...o&userid=16502
View this thread:
http://www.excelforum.com/showthread...hreadid=278897