lookup info in another worksheet
 

i've assigned dept codes to a list of vendor information. the vendor sheet
looks like:

vendor# vendor name address dept code

i'm already running a vlookup from this sheet to another. i would like to
run a separate function that will pick the account names for each code and
list them in a new sheet. how?
--
steph