try something like =lookup($I$33,{0,40,60,80},{50,100,150,200})
You can replace the series between brackets with ranges containing the
values


--
Pecoflyer

Cheers - MS Excel Newbie
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=41087