elsuji
12-27-2019, 10:45 AM
Dear Team,
I am having data (Name and Email ID) from Sheet 2.
In sheet 2 names listed on B6:B23 and Email Id listed on C6:C23.
In Sheet1 "D1" i had created drop down list of names. When i am select name on drop down list on D1 the email is should display on G1.
For example, I select the name which is on Sheet2 B6, the email id should display from C6. If i selected B9 then email id should display from C9.
Can any one help to create code for the above condition.
My file is attached with this mail for reference
I am having data (Name and Email ID) from Sheet 2.
In sheet 2 names listed on B6:B23 and Email Id listed on C6:C23.
In Sheet1 "D1" i had created drop down list of names. When i am select name on drop down list on D1 the email is should display on G1.
For example, I select the name which is on Sheet2 B6, the email id should display from C6. If i selected B9 then email id should display from C9.
Can any one help to create code for the above condition.
My file is attached with this mail for reference