Prev: Does a formula exist that will lookup on ALL tabs, not just one.
Next: Filter duplicates based on criteria / column values
From: Ron L on 9 Apr 2010 16:01
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.
From: Ron L on 9 Apr 2010 16:09
***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)

"Ron L" wrote:

> 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.
From: Don Guillett on 9 Apr 2010 16:09
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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Ron L" <RonL(a)discussions.microsoft.com> wrote in message
news:6B852B40-6E23-4E25-A198-E78D8F6CAE96(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Does a formula exist that will lookup on ALL tabs, not just one.
Next: Filter duplicates based on criteria / column values