You might try going under Data - Filter, apply AutoFilter.
You can then use the drop-downs to limit your list to your particular
criteria.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Vegeta_matt18" wrote:

Does anyone know if it is possible to have say two fields where you can enter
search criteria to gain the results in a separate list?

Eg.

Animal Colour Name
Dog Brown Rob
Dog Black Fred
Cat Brown Phil
Cat Ginger Mark
Dog Brown Bill


If the search criteria was Dog and Brown I waould like the response to be as
below:

Animal Colour Name
Dog Brown Rob
Dog Brown Bill

Thanks in advance for any assistance :)