wow you're an absolute genius!!! thank you so much, I think this is just what I was looking for. I'm gonna experiment and try to learn this throughout the day. I did come across something similar to this formula yesterday but it only worked if you lined up the definitions in the same rows as your drop downs. anyway, I never would have gotten this on my own, I'm so glad I asked and it's such a relief. thanks a million!!