IMO use Access for something like this. Excel is good when you want to
analyze numerical data. It is not really designed for relating items together
(such as a technician to skills). For that a relational database is a much
better choice. Especially since you probably want to have a large number of
users trying to access the data concurrently. Excel is distinctly poor at
allowing concurrent access to a single point source of data.

In Access I would be inclined to set this up as paired values so that you
end up with only two or three columns in your table.
Tech Equipment Brand
John TV Sony
John TV Phillips
John Stereo Sony
Dave TV Sony

This would allow for very simple queries by equipment type or brand... You
could even make the front end in XL to access the data in the Access Tables
if you want.
--
HTH...

Jim Thomlinson


"HERZHIS" wrote:

I have to design a table of our technicians skills by 3 category level so it
makes it easy for the salemen to see what technician would be good for the job

Example:
Equipment (TV) - Equipment Type(Sony,Hitachi,Magnavox,etc) - Skill
Level(Electrical,Mechanical,Programming) - Technician

I need something where the salemen can bring up by Equipment Type and skills
to see which techs would be the man for the job


--
Thanks again, Herz and His