VLOOKUP - location of found value?

[Karl]

Rather than know the value found by VLOOKUP, I need to know the return
value's cell's reference. Is there anyway to determine this?

The reason for needing to know this, is because the spreadsheet is
constructed with data arranged in a matrix of cells. In the cell to the left
of the top left corner of the matrix is an INDEX value. VLOOKUP looks up the
data based on this INDEX. However, we want to be able to pick values out of
the matrix and I think that OFFSET() would be a good way to do this.
However, I need the location of the INDEX in order to do this. Or do I?

Or ultimately, I'm trying to normalize the data found in each of many
hundreds of matrixes.

TIA.

 

[Frank Kabel]

Hi
have a look at the MATCH function. This return the
relative position of the found element

 

[JulieD]

Hi Karl

=ADDRESS(MATCH(D2,A1:A100,0),1)

will give you the position of whatever is in D2 where it is found in the
range A1:A100

hope this helps

Cheers
JulieD