You can use VLOOKUP but your data will need to be in ascending order by the
lookup column.

=VLOOKUP("237.50",A1:B19,2,0)

HTH,
Paul

"yazmaz" wrote in message
...
I have two columns of numbers, A1 = volume & B1 = an associated time
interval. I need to look down column A and find the first time a specific
value appears and then capture its corresponding value in column B to use
in
another formula.
Ex: I need to find 237.50 in A and use the corresponding 117.8. Thanks
Col A Col B
220.70 5.60
203.90 12.20
187.10 18.80
170.30 25.40
153.50 32.00
136.70 38.60
119.90 45.20
103.10 51.80
86.30 58.40
69.50 65.00
93.25 71.60
117.00 78.20
140.75 84.80
164.50 91.40
188.25 98.00
212.00 104.60
235.75 111.20
237.50 117.80
237.50 124.40