Have you tried highlighting the data that you want to filter and then Tools => Filter => Autofilter? Or is that not what you mean?
It only restricts the rows that you want to show but does not affect any totals etc.

Another option is perhaps the VLOOKUP or HLOOKUP functions.