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
Reply With Quote