Alan Beban wrote:
If you use row and column headers (first criteria and second criteria)
that are valid range names, then highlight your data range, including
the headers, click on Insert|Name|Create and check Top row and Left
column, then OK, you can use the "Intersection Operator", i.e., the
space. E.g.:

CriterionC1 CriterionC2 CriterionC3
CriterionR1 $1 $2 $3
CriterionR2 $4 $5 $6
CriterionR3 $7 $8 $9

=CriterionC2 CriterionR3 will return $9
=CriterionR3 CriterionC1 will return $5, etc.

Wow! I don't know how I did that. It should of course be

=CriterionC2 CriterionR3 will return $8
=CriterionR3 CriterionC1 will return $7, etc.

Alan Beban