I need to check a range and identify each situation where two cells match my
criteria, and in those situations, return the text value of one of those
cells.

My attempts so far which include sumproduct, match, sumif, etc don't seem to
work; sumproduct and sumif seem to want numeric values, match isn't working
because I have to use a wildcard character and the first match is not always
the right one, and I haven't found anything else that will evaluate multiple
cells and return a text value only when both cells meet my criteria.

Are there any other formulas I should play with? I'm reluctant to use array
formulas because this formula will include sumproduct and other formulas, and
my initial testing wasn't fruitful, and I was thinking it might have to do
with entering things like a sumproduct Within an array formula.

=Count(And(criteria1, criteria2))
does provide the expected result (1 match); I just can't figure out how to
tell which column it is in, and return the text from one of my target cells.

I welcome any advice-

Thank you,
Keith