Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
assign file numbers to names
There are about 500 managers, when I choose a manager's name from a drop down
(in a form) I want excel to insert the manager's file number in an adjacent cell. i.e. Joe Button - 1875 Sally Field - 1745 Carl Redding - 1590 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
assign file numbers to names
Try this:
Say you have the list feeding the drop down in A5:A7 and the manager file numbers in B5:B7 In column D put the drop down list letting the users pick the manager In column E, next to the managers name, put the following formula =IF(ISBLANK(D5),"",VLOOKUP(D5,$A$5:$B$7,2,FALSE)) The ISBLANK function is used to prevent error indicators from appearing when a cell in column D is empty Perhaps add protection for the data in column E "NeSchw6G" wrote: There are about 500 managers, when I choose a manager's name from a drop down (in a form) I want excel to insert the manager's file number in an adjacent cell. i.e. Joe Button - 1875 Sally Field - 1745 Carl Redding - 1590 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
assign file numbers to names
It worked! Thank you!
"Flick Olmsford" wrote: Try this: Say you have the list feeding the drop down in A5:A7 and the manager file numbers in B5:B7 In column D put the drop down list letting the users pick the manager In column E, next to the managers name, put the following formula =IF(ISBLANK(D5),"",VLOOKUP(D5,$A$5:$B$7,2,FALSE)) The ISBLANK function is used to prevent error indicators from appearing when a cell in column D is empty Perhaps add protection for the data in column E "NeSchw6G" wrote: There are about 500 managers, when I choose a manager's name from a drop down (in a form) I want excel to insert the manager's file number in an adjacent cell. i.e. Joe Button - 1875 Sally Field - 1745 Carl Redding - 1590 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to randomly assign numbers to names? | Excel Discussion (Misc queries) | |||
Assign charts names in VBA? | Excel Discussion (Misc queries) | |||
assign numbers a value, then get percentage | Excel Worksheet Functions | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Assign values to names in a drop-down list? | Excel Discussion (Misc queries) |