Is there a function that can do a lookup but pull in multiple rows of
information. Example: I have an ID# in column one and a comment pertaining
to that ID# in column 2. I will have several comment lines for one ID # over
time. I need all those comments together. Vlookup only pulls one line of
them.

Thanks

Depending on what you are doing............the AutoFilter ( Data Filter
AutoFilter) will bring in all the lines of same ID# and their associated
columns of comments........

Vaya con Dios,
Chuck, CABGx3




"Tanya" wrote in message
...
Is there a function that can do a lookup but pull in multiple rows of
information. Example: I have an ID# in column one and a comment
pertaining
to that ID# in column 2. I will have several comment lines for one ID #
over
time. I need all those comments together. Vlookup only pulls one line of
them.

Thanks