maybe this would work,
if your dropdown menu is in A1 and the formula is in B1
=IF(A1="a",1,IF(A1="B",2,IF(A1="c",3,IF(A1="d",4,I F(A1="e",5,IF(A1="all",6,""))))))


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=555539