Hi Kara

sounds like a VLOOKUP should do what you want, assuming your table
containing the department, code & description is on Sheet3 range A2:C100.

and the cell that the Help Desk is filling in the department on is cell A2
on sheet1, and you want the appropriate code & description filled in in
cells A2 and A3 respectively on Sheet2.

the formula for Sheet2 A2 would be
=VLOOKUP(Sheet1!$A$2,Sheet2!$A$2:$C$100,2,0)
and for Sheet 2 A3
=VLOOKUP(Sheet1!$A$2,Sheet2!$A$2:$C$100,3,0)

hope this helps

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Kara" wrote in message
...
Hi,

I am a beginner at Vlookup but I understand this should solve my problem.
If someone could explain I would appreciate it.

I have an excel spreadsheet that a HelpDesk will fill out and pass onto me
for account creation. When they enter in a deparment I would like that to
look at a table and from that table enter in a code and description for
that
department automatically on a second sheet in two different cells.

Thanks you for your help!