look up and append result to row for multiple identical entries

Works like a charm!
Can I send you flowers?!?

as

PS: actually, just ran into a problem:
I have several ID numbers that appear more than 250 times.
That means I'll run into the problem that the worksheet is not "long" enough.

Apart from "use a database and not Excel", does anybody know a solution to this problem? Like writing the whole thing as one row to a text file, for example?

Thanks!

as