one ref, could be many returns

[Hsibbs]

I have the code 117 in my first db, in another db I may have 50 records with 117 in column A, column B has a name, I want to put ALL these names next to 117 , in the same row on my first db.

What is the best way to do this, using a technique easily repeatable?

THNX

sibbs

 

[JackDanIce]

If it's a database, you'd better of asking this in the database section, rather than Excel.

Sounds like you require a one-to-many query and then do something specific with the output