Drop down list and filtering data

[jcfz6r1]

Hello,
I have an interesting question about drop down lists and showing data.

I have a list of names, and another list of machinery. sort of like this:

Jim-------hammer
Bob------screw driver
Mike-----flash light
Steve----pliers

And I want to use a drop down list to show me who can work with what tools and who cannot with either a yes or no, like this:
------------tools-
-name----"drop down"
Jim----------yes
Bob---------yes
Mike---------no
Steve-------no

So I can select a tool from the list, and it will enter either a "yes" or "no" next to each persons name as to whether or not they can work with the selected tool? Hope that makes sense.

I realize I need to enter somewhere what guys can work with what tools, but I want to be able to have a nice clean way to look that all up.

I'm not even sure if it is possible to do what I want here, since my excel formula experience is pretty limited.

Any help would be appreciated.

Thanks,
-Josh