Lookup based on several criteria

Hello all,

I have a list that includes, among other things, 3 pieces of information.

Part #, Packing Slip #, Invoice #

In a second workbook, I have Packing Slip and Part #. I need to match the Invoice # to this data. My problem is that a single packing slip can refer to several parts, each of which has its own invoice. A vlookup would only yield the first invoice that matches the packing slip (or part, depending on how I set it up).

Is there a way to search a list using several criteria?

In words = find invoice# that matches packing slip#(XX) and part#(YY).

Thanks for any advice you can give,
the_giza