Principially yes.

With SUMIFS(), you sum a range applying conditions on another ranges. The ranges involved must be of same dimension (and I belive single-column/row ranges), and the sum range must be numeric/date/boolean (condition ranges and values can be of any type). Condition values can be values in some cell in table or elsewhere in workbook, names, values returned by formulas (p.e. another SUMIFS formula), or constants. The number of condition pairs (range + value) is limited only with max number of characters for Excel formulas. Originally the formula is meant to calculate sum, but by using right conditions is it possible to use it like lookup for numeric value from table.

Another useful function is COUNTIFS(). Works similarily, but contains only Range-Value pairs, and counts records or rows mathing with all conditions.