Look up and return data

[Ron L]

Is there a formula that will look for matching information (example: customer
#) in column A and return all the corresponding information in column B to a
single cell in column C. Note: There will be numorous cells of information
from column B that will need to be returned to a single cell in column C.

 

[Ron L]

***EDIT****

I want to perform this function automaticly when the information is put into
the workbook without physicly typing customer# into another cell as with
VLOOKUP (if that makes sense)

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.