| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP ON LINKING DATA TO DROP DOWN LIST | Excel Discussion (Misc queries) | |||
| Linking a cell to a drop down list | Excel Worksheet Functions | |||
| Drop down list linking | Excel Worksheet Functions | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| Linking Drop-down list to worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
