Hi All,


I have two sheets.
The first sheet, which we'll call "WORK TYPES" has two colmuns.
Column A has a work type number followed by a comma and column B has
the description associated with the number. Each row is a single work
type.

Example:

15, Pavement Markings
16, Guide Rail
17, Signs
18, Fence
19, Seeding

The second sheet, we'll call "CONTRACTORS" where column A contains the
contractors name, column B where I would type in the work type numbers
and column C which would contain a VLOOKUP fomula to find the worktype
description from the "WORK TYPES" sheet.

Now suppose one contractor does more that one type of work. How would
I write the formula?

Example of desired results:

AJAX, Inc. 16, 17, 18, Guide Rail, Signs, Fence



Thanks for any help that you can give me.

Tom