How about this:
It will round the value in C1 up to the nearest multiple of 0.25 then
lookup that value

=VLOOKUP(CEILING(C1,0.25),A1:B9,2)


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=278328