Link info in one cell to info in several cells in another column (like a database)

Trying to create an excel form for administration of roles and competencies in my department. There are like 50 roles and 150 competencies. Each role is composed of 5-10 competencies. Therefore, I would like to link a role to several competencies (to avoid redundancy). Is that possible to do with Excel or will I need to use a DB?

You can link cells in Excel, but someone may be able to provide specific
advice if you provide more details about your workbook, and data, and
what you're trying to link.

hansdiddy wrote:
> Trying to create an excel form for administration of roles and
> competencies in my department. There are like 50 roles and 150
> competencies. Each role is composed of 5-10 competencies. Therefore, I
> would like to link a role to several competencies (to avoid
> redundancy). Is that possible to do with Excel or will I need to use a
> DB?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html