I'm trying to build an output formula for some information I need but haven't
seen anything like it. Here's what I'm doing:

On the first tab I have a list of light fixtures.
Cells A1..A# contains the quantiy of light fixture per type
Cells B1..B# contains the "tag" name of the fixture (A, B, B1, EX, etc).
Cells C1..C# contains the lamp style (eg... F032T8/835).
Cells D1..D# contains the number of lamps per each fixture.

On the 2nd tab sheet I have an output area that creates a list of the lamp
types and the totals for each lamp type.
In cell A1..A# I type the lamp styles I'm using on a particular job that
match one of the lamps from the C1..C# range on the first tab-sheet.
In cell B1..B# I'm using SUMIF to make a total for all the lamps used on the
job from the first tab sheet that match my criteria as typed into cell A1..A#
on this tab sheet.
The next cell forumula is the one I need help with. In cell B1..B# I need a
formula that will give me the "tag" names of the fixtures that meet the lamp
criteria on this tab sheet that I typed in cell A1..A#.
I would prefer it look like this: "Fixture Types ?, ?, ?, ?". If that's not
possible, I could work with something more simple like just "?, ?, ?, ?"
where "?" is the fixture "Tag" name from the first tab sheet for every
fixture that uses the same lamp type.

I hope this all makes sense. I tried to keep it simple but if someone thinks
they have a solution for this one but needs more info I can email you the
sheet I'm working with.

Thank you.
--
Steven Leuck
Builders Electric, Inc.