You just need to sort your list ascending based on the first column.
Then you can use a vlookup as follows:

=vlookup(A1, A4:B10,2)

The A4:B10 is the area where you have your data table shown in your
original post. The vlookup will go to the nearest value that is less
than or equal to it and then pull the second column. Let me know if
you need a hand. Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=381077