Excel automation

[arnab0711]

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

[shg]

Please take a few minutes to re-read the forum rules, and then start a new thread with a descriptive title.

Thanks.