Q:

Is there any method to get the address of the result?

When I use the filter or query to get the result, I want to get the address of the result.
The result is a string type, But column() or row() methods just accept the range on the parameter.
Is there any method to get the address?
Such like the original function address(1,2,4) result (B1) 

A:

=CELL("address", INDEX(A2:A, MATCH(
 FILTER(A2:A, A2:A="Nancy"),
 A2:A, 0), 1))

_______________________________________________________________
=REGEXREPLACE(CELL("address", INDEX(A2:A, MATCH(
 FILTER(A2:A, A2:A="Nancy"),
 A2:A, 0), 1)), "\$", "")

