YEA!!!!!! I figured it out, it takes a combination of data validation
dependent list, and vlookup. Thanks to all who helped!!!


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=467934