Hi,

Try this instead:

I have assumed anything less than 163,000 would result in 0:

=LOOKUP(G8,{0,0;163000,1000;187450,3000;23412,3000 ;244500,4000})


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=491796