using lookup to find the first occurance greater than X

[millertime_2004]

I have a table of data that I need to return a the first occurrence greater than my criteria. I have tried a few options found using the search here and have not had any luck, it always returns the last instance. I have tried LOOKUP, and VLOOKUP.

Column A Column B
<table width="243" border="0" cellpadding="0" cellspacing="0"><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:4900;width:101pt" width="134"> <tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:82pt" width="109" align="right" height="17">4.167</td> <td style="width:101pt" width="134" align="right">2</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">3.188</td> <td align="right">1.9</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">0.251</td> <td align="right">1.8</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">1.707</td> <td align="right">1.7</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">2.687</td> <td align="right">1.6</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">4.645</td> <td align="right">1.5</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">6.114</td> <td align="right">1.4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">5.624</td> <td align="right">1.3</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">2.197</td> <td align="right">1.2</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">6.126</td> <td align="right">1.1</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">24.729</td> <td align="right">1</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">58.998</td> <td align="right">0.9</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">94</td> <td align="right">0.8</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">202.93</td> <td align="right">0.7</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">323.362</td> <td align="right">0.6</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">458.971</td> <td align="right">0.5</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">586.258</td> <td align="right">0.4</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">689.556</td> <td align="right">0.3</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">760.542</td> <td align="right">0.2</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">792.853</td> <td align="right">0.1</td> </tr> <tr style="height:12.75pt" height="17"> <td style="height:12.75pt" align="right" height="17">799.707</td> <td align="right">0
</td> </tr> </tbody></table>

I am looking to return the first occurance in Column B where Column A is greater than 95, so I should get 0.7. please help

 

[sheetspread]

Excel Workbook
	A	B	C	D
1	4.167	2
2	3.188	1.9
3	0.251	1.8
4	1.707	1.7
5	2.687	1.6
6	4.645	1.5
7	6.114	1.4
8	5.624	1.3
9	2.197	1.2
10	6.126	1.1
11	24.729	1
12	58.998	0.9
13	94	0.8
14	202.93	0.7
15	323.362	0.6
16	458.971	0.5
17	586.258	0.4
18	689.556	0.3
19	760.542	0.2
20	792.853	0.1
21	799.707	0
22
23			95	0.7
Sheet1

 

[xlHammer]

Try this

=INDEX(B1:B21,MATCH(1,--(A1:A21>95),0))

entered as an array formula (ie using ctrl + shift + enter)

so it looks like this in the formula bar,

{=INDEX(B1:B21,MATCH(1,--(A1:A21>95),0))}

 

[millertime_2004]

yeah xlHammer, that works great, thanks