i tried posting this under excel functions, but perhaps that was the wrong
place to ask this question. i'd like to run a code or something that will
pull the text information from one column based on a matched number in
another column, and list that text in a separate 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. is this possible? i've seen functions to sum up
the number of occurrences, but i'd like to list each occurrence. how?
--
steph

--
steph