Can Hlookup and Vlookup return an address?

i need to construct a formula that will look up a value in a row, and then
look up another value in that column (there may be more than one of the same
values in that column). i need the address of the value that is found in the
column

With questions like this it helps to know the layout of
the data with regard to specific rows and columns. Let's
start with this:

Let's assume you're trying to locate the number 88 in row
1, and once its found, you want to identify the location
of the word apple. You could use:

=ADDRESS(MATCH("apple",OFFSET(A1,,MATCH(88,1:1,0)-
1,1000),0),MATCH(88,1:1,0),4)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can Hlookup and Vlookup return an address?

i need to construct a formula that will look up a value
in a row, and then
look up another value in that column (there may be more
than one of the same
values in that column). i need the address of the value
that is found in the
column
.

thats the strategy i was looking for

thanks Jason!

"Jason Morin" wrote:

With questions like this it helps to know the layout of
the data with regard to specific rows and columns. Let's
start with this:

Let's assume you're trying to locate the number 88 in row
1, and once its found, you want to identify the location
of the word apple. You could use:

=ADDRESS(MATCH("apple",OFFSET(A1,,MATCH(88,1:1,0)-
1,1000),0),MATCH(88,1:1,0),4)

HTH
Jason
Atlanta, GA

-----Original Message-----
Can Hlookup and Vlookup return an address?

i need to construct a formula that will look up a value
in a row, and then
look up another value in that column (there may be more
than one of the same
values in that column). i need the address of the value
that is found in the
column
.