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 |
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) |