Re: How to Create a Formula Based on Multiple Conditions

bperry1792 I'm glad this worked out for you.  and thank you to mathetes for the f/u post on a formula showing how to use that table.  There are so many options I was going to try a couple to see what I felt was the most versatile but easy to show but was also short on time, so I'm glad mathetes could hop in.  As for VBA I have experience but honestly never generated e-mails (not that it is hard).  I have no problem reviewing and tweaking a macro but not interested in creating it (I feel when I create VBA code/macro there is more ownership of it and therefore whenever something stops working or needs updating, well you get the idea and I already of 3 actual jobs and this is my 'fun' time).  That said, it sounds like you already found some sample code.  There isn't a ton difference between numbers and text when you are doing comparisons, you just can't do math with text, but with text you may use 'search' to see if a string is found inside another string (e.g. "Mathetes" might be in the spreadsheet as "@Mathetes", "Mathetes Inc", "Mathetes & Co.", etc and you want the find to catch any of them).

Lastly, if YOU try to do it you will learn a lot more than if someone does it for you.  So I recommend trying to do it, then make a new post (a new post will get better visibility for community members that do VBA to jump in) with what you are trying to do, the macro code you've done and questions about any help you need.  I hope I see that post and can help.