Select One
in [Programming]
|
Prev: Save As Webpage - include my own HTML??
Next: Dealing with unknown array sizes (Application.Transpose)
From: Joe on 8 Mar 2010 15:41 You guys have helped me before, so I am back. I have 200 employees divided among 15 Supervisors. If I create an Excel spreadsheet cell with a drop-down menu of employees, once an employee is selected from that list, what formula can I use to have Excel populate the employee's Supervisor name in a cell to the right? Example: (two cells – cell #1 selected through a drop-down menu – Cell #2 is automatically populated when a name is chosen in cell #1) Employee Supervisor John Smith Bill Thompson I have already created two separate columns, one with the employee names, the second with the Supervisor name. Thank you.
From: Gord Dibben on 8 Mar 2010 16:19
VLOOKUP Gord Dibben MS Excel MVP On Mon, 8 Mar 2010 12:41:01 -0800, Joe <Joe(a)discussions.microsoft.com> wrote: >You guys have helped me before, so I am back. > >I have 200 employees divided among 15 Supervisors. > >If I create an Excel spreadsheet cell with a drop-down menu of employees, >once an employee is selected from that list, what formula can I use to have >Excel populate the employee�s Supervisor name in a cell to the right? > >Example: (two cells � cell #1 selected through a drop-down menu � Cell #2 is >automatically populated when a name is chosen in cell #1) > >Employee Supervisor >John Smith Bill Thompson > >I have already created two separate columns, one with the employee names, >the second with the Supervisor name. > >Thank you. |