hlookup & addresses
 

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

hlookup & addresses
 

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
.

hlookup & addresses
 

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
.