Search using drop down list

[xjharmony]

I would like to create a seach function to select employees with a particular functionality. In a matrix I would have the names of employees on one axis, with types of functions on the other axis. I would then have ticks for every function a particular employee has. I would then like to be able to search for the function in a drop down list, and come up with a list of employees who are able to do it. Is this possible? It would be used by employees working on a project who need to find people with certain skills.

Thanks for your help.

I am using MS Excel 2010

 

[T. Valko]

I would like to create a seach function to select employees with a particular functionality. In a matrix I would have the names of employees on one axis, with types of functions on the other axis. I would then have ticks for every function a particular employee has. I would then like to be able to search for the function in a drop down list, and come up with a list of employees who are able to do it. Is this possible? It would be used by employees working on a project who need to find people with certain skills.

Thanks for your help.

I am using MS Excel 2010

How much data has to be searched through?

How many employees are there?

How many functions are there?

 

[xjharmony]

There will be two tables on seperate sheets. One for function, one for work type. Example function could be estimating or scheduling and work type could be roads or bridges. There is 53 employees along the top of each sheet with 16 work types and 18 functions. My ideal solution would involve two search drop down boxes where you can select a work type in one, a function in the other, and have a resulting list of all the employees who are ticked off against both.

 

[T. Valko]

There will be two tables on seperate sheets. One for function, one for work type. Example function could be estimating or scheduling and work type could be roads or bridges. There is 53 employees along the top of each sheet with 16 work types and 18 functions. My ideal solution would involve two search drop down boxes where you can select a work type in one, a function in the other, and have a resulting list of all the employees who are ticked off against both.

In your initial post you mentioned 2 variables but now there are 3, plus, there are 2 tables to look through.

Hmmm...

I don't know about doing this with formulas. Sounds like you need some VBA programming.

I'm not much of a programmer so I think someone else will need to help you with this.

Good luck!