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