how to search multiple col/row table wit multiple criteria to return lowest value

I need to search a 6 col, 2000 row table to find 3 items that match 2 and sometimes 3 criteria and return the lowest value of the multiple items that match.
Any help would be appreciated!!!