Xlookup multiple match criteria

Hi - I would like to use a look up table to return an exact match based on multiple criteria (like an AND nesting in an IF function).  My data does not have a single key so I need to match 3 differen...