Hi

Change the A2+90 to A2+99.9999 or similar.
Sorry, I didn't realise you'd be using decimals.

Andy.

"bradles" wrote in
message ...

Hi

Try something like this, with your value in A2
=HLOOKUP(A2+90,B3:AC3,1,TRUE)

Hope this helps.
Andy.
That almost had it Andy. Only problem is: what if the number is 250.1.
I need that to be rounded up to 350 because it is greater than 250.

Your formular in that case would be looking up 250.1+90 = 349.1. So it
would still drop down to 250.

Any more ideas?

Brad


--
bradles
------------------------------------------------------------------------
bradles's Profile:
http://www.excelforum.com/member.php...nfo&userid=998
View this thread: http://www.excelforum.com/showthread...hreadid=569322