Linking Drop Down List
 

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

Linking Drop Down List
 

In Log,

Think something like this in O2, copied down, should work ok:
=IF(G2="","",VLOOKUP(G2,'Assigned To'!A:B,2,0))

If anything, the DV in G2 down, created based on values in col A in
'Assigned To' as posted, should help to ensure 100% matching for the vlookup.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Melissa McCracken" wrote:
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

Linking Drop Down List
 

This worked..........Thanks

"Max" wrote:

In Log,

Think something like this in O2, copied down, should work ok:
=IF(G2="","",VLOOKUP(G2,'Assigned To'!A:B,2,0))

If anything, the DV in G2 down, created based on values in col A in
'Assigned To' as posted, should help to ensure 100% matching for the vlookup.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Melissa McCracken" wrote:
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

Linking Drop Down List
 

welcome, glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Melissa McCracken" wrote in
message ...
This worked..........Thanks