Automatically fill cells when selecting from a drop down list

[Liotta]

Hi - I want adjacent cells to automatically fill in when I select an item
from a drop down list. For example, my list contains Manager, Supervisor; GA
and if I click 'Manager' I want certain corresponding cells to autofil and if
I click 'GA' I want other cells to fill. Can anyone help??? Thanks

 

[Ashish Mathur]

Hi,

Please refer to Excel's VLOOKUP() function. Please type VLOOKUP() function
in Excel's Help menu.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Liotta]

Hi Ashish - thanks for your prompt reply - can I just check something? For
example if have a list of training courses going across the colums and I've
created a drop down list of job roles. What I want to happen is, if I click
Manager then a 'YES' is automatically entered into the cells under all the
training courses that a manager should do? Is it still VLOOKUP I should be
trying to master? Thanks again!

 

[Ashish Mathur]

Hi,

Looks like. IF you face a problem, please mail the specific question.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com