Harlan,

Thanks. This works even better.

Les

"Harlan Grove" wrote:

Les wrote...
....
Name Age Sex (Header row)
Brown 42 M
Smith 31 F
Bush 55 M

=ADDRESS(MATCH("Smith",A,0),1,4,TRUE)

will give me the result "A3", which is the correct address for "Brown".

Presumably you mean the correct address for Smith.

What I really want is the age or sex for brown. . . .

Why not use

=VLOOKUP("Smith",$A$1:$C$100,2,0) for age

=VLOOKUP("Smith",$A$1:$C$100,3,0) for sex

?