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!