Ended up placing this formula on a hidden admin sheet that I already
had, and used the indirect function under data validation.

=NOT(ISERROR(MATCH(G6,E16:E39,0)))

Thanks for all the help.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=550168