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

Maybe you could use a pivot table to create a summary of the various
relationships - rather than code?

--
Cheers
Nigel



"steph" wrote in message
...
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

interesting idea--i'll try it. thanks!
--
steph


"Nigel" wrote:

Maybe you could use a pivot table to create a summary of the various
relationships - rather than code?

--
Cheers
Nigel



"steph" wrote in message
...
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

it worked! eternal gratitude.
--
steph


"steph" wrote:

interesting idea--i'll try it. thanks!
--
steph


"Nigel" wrote:

Maybe you could use a pivot table to create a summary of the various
relationships - rather than code?

--
Cheers
Nigel



"steph" wrote in message
...
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