vlookup

[Guest]

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

 

[CLR]

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