Hi,

I have two spreadsheet databases (each in separate sheets) with the
following information in them: the first one contains records about
"projects" with each project having a unique number. The second spreadsheet
database contains details about contractors assigned to a project. In this
database, a "project" may have multiple records - one for each contractor
assigned to the project.

I'm trying to create a "report" in a sheet in which I can put the project
number in a cell, and formulas will return all the contractors assigned to
that project. I have tried to use =vlookup() and =match()... and they work
to return the first record...

How can I set formulas up so that I can return all the contractors assigned
to a project? In other words... let's say the max # of contractors assigned
is 10. Then I would like to have 10 cells in my report... each with a
formula (similar to match() or vlookup()) that will return the contractors
assigned to that project from the correct database.

Any ideas on how to set this up would be very helpful and much appreciated -
thanks in advance.