'I understand that vlookup will only return the first match it finds'

Yes, it will only do that, try SUMPRODUCT to find two or more criteria,
For example, if in A1:A50 you had 'Cats' and 'Dogs' entered randomly in
those
cells, and in B1:B50, also randomly you had 'Male' and 'Female' then:-

=SUMPRODUCT(--(A1:A5="Cats"),--(B1:B50="Female"))

will return the nunber of Female Cats contained in the two lists.
You can also have 'Cats' in say E1 and 'Female' in E2, then he formula would
be

=SUMPRODUCT(--(A1:A5=E1),--(B1:B50=E2))

Probably best to play around with this until you've got it clear in your
head, then go onto the dropdown you want.
It's very do-able, but one thing at a time,
Regards,
Alan.
"Kevin" wrote in message
...
I have a list of employees and a list of tasks. I have a third column that
tells me if an employee is qualified to perform a task. I would like to
make
a dropdown where I can select a task to be done and have it return a list
of
any and all employees who are qualified to perform that task. I understand
that vlookup will only return the first match it finds. How can return
more
than one answer to choose from? Thanks