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