roly Wrote:


How many criteria are there in the list? If there only a few, you
could put it in an IF statement.



Eighteen. I could do it that way or by naming the ranges that I want
to select from, but if there's a cleaner way to do it, that's my
preference.

Thanks for your help!


--
trempnvt
------------------------------------------------------------------------
trempnvt's Profile: http://www.excelforum.com/member.php...o&userid=34710
View this thread: http://www.excelforum.com/showthread...hreadid=544779