I have a Work Request Spreadsheet with two worksheets: 'Log' and 'Assigned To'
Worksheet 'Log' contains Column G-'Assigned To' and Column O-'EMail'
Worksheet 'Assigned To' contains Column A-'Name' and Column B-'EMail Address'
I have named a list on Worksheet 'Assigned To' using Column A 'Name' and use
it in a drop down box on Worksheet 'Log'--Column G-'Assigned To'
I would like to create a formula for Worksheet 'Log'--Column O-'EMail' that
would pull the email from Worksheet 'Assigned To'--Column B-'EMail Address'
associating it with the name in Worksheet 'Log' Column G-'Assigned To'
I have tried to use VLOOKUP and this has not worked, possibly because
Worksheet 'Log'--Column G-'Assigned To' contains a drop down box.
Is this possible?
Any assistance would be appreciated