Thanks Bob. It worked.

One more question...

If I wanted to do a vlookup that incorporated that logic, what forumla
could I use?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=513868