Cell Content Lookup Function

[Les]

I have a worksheet of 5 columns and many rows w/ a header row. The contents
will change daily. Col A (unique) is the search key and I want to lookup the
contents in Col B and on.

Example Worksheet

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".

What I really want is the age or sex for brown. I am not having any luck
with Cell (Contents) function. Am I doing this the correct way or there is a
better way of doing it?

Thanks
Les

 

[Harlan Grove]

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

?

 

[Les]

Harlan,

Thanks. This works even better.

Les

Presumably you mean the correct address for Smith.


Why not use

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

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

?