If you need to drag this formula down the column then you need to make
the references absolute:

=IF($M$30=0,"",if($M$300,CHOOSE($M$30,Lists!$D$2, Lists!$D$3
,Lists!$D$3,Lists!$D$4,Lists!$D$5,Lists!$D$6,Lists !$D$7,List
s!$D$9,Lists!$D$10,"","",""),""))


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=489831