Add multiple IF's before calling email macro in excel BVBA

i am new to this and have little experience creating macros in VBA in Excel. Currently i have a workbook that will send an email when Column F is changed. That works fine, but i want to add different email addresses based on the information in Column A.

I imagine it works like this: Column F is changed, if Column A has XXXX send to joe.sample@email.com, if Column A has YYYY send to mary.sample@email.com, If Column A has "AAA, BBB, CCC" send to maryjoe.sample@email.com.

As you can see, anytime Column F changes somebody gets an email, but not everybody gets every email.

If this needs to be clarified, please let me know. This is my first post.

Thanks