Solved: Return cell address of VLOOKUP

[Marcster]

How do I return the Cell Address of the result from a VLOOKUP?. :help

Example:
=VLOOKUP("Marcster",A16:B22,2,FALSE) in cell D18 which returns
the value in column B. It's this value in colomn B I need the address of.

Thanks,

Marcster.

[vonpookie]

This seems to work for me--it's using Index/Match instead of VLOOKUP, though:

=ADDRESS(ROW(INDEX(A16:A22,MATCH("Marcster",A16:A22,0),1)),2)

[mdmackillop]

For any cell in column A
=ADDRESS(MATCH("Marcster",A:A,0),2)

[Marcster]

Thanks, got it working now, I typed it in Excel wrong...

Thanks again,

Marcster.

[mdmackillop]

Vonpookie's code works for me.