help! pull text info from separate worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Maybe you could use a pivot table to create a summary of the various
relationships - rather than code?
 
interesting idea--i'll try it. thanks!
--
steph


Nigel said:
Maybe you could use a pivot table to create a summary of the various
relationships - rather than code?
Click to expand...
 
Back
Top