Dropdown Assigning

edited 12/09/19 in Smartsheet Basics

I have a program that imports data from an excel sheet. The data contains names of a project manager and a project ID. I have a dropdown list containing all the PMs and their emails, and what I was wondering was when I populate the PM column with the PMs name, is there any way to attach the corresponding email of the PM so that they may receive a notification of the project being added. Currently when I run the program, it simply adds the PMs name to the cell, but does not assign it the email.