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" wrote:

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" wrote in message
...
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