Excel automation

Hi All,
I am attaching a file where I want to automate Column D (Business Group) as follows,
If the Material group is "M" and Plant is "5308" business group will be AQLN,if P.GRP is "NLZ" and Plant is "5308" business group will be

"PTV 3rd Party" and for the rest of "Business Group" is "PTV" for Plant "5308"
Thank you in advance for the help