I think LOOKUP returns #N/A if lookup-value is smaller than the smallest
value.


Pete Wrote:
You could try the lookup formula, but with a very small number, eg
1E-200.

Hope this helps.

Pete


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=504215