I have a spread sheet with various information for example:

cell 1 cell 2 cell 3 cell 4 cell 5 cell 6 cell 7 cell 8 cell 9
ITM01 S/N Model Company misc name WR number Dept ID Dept mgr.

What I need is when I fill in cell 6 with a particulair name I would like that to automacticlly fill in cell 8 with a Dept. ID and cell 9 with Dept. Mgr. with this info.

What do I need to do to make this happen ??

Thanks,

Russ