Is there any formula which can give cell address of occurence of a
vlookup formula.
Thxs

wrote...
Is there any formula which can give cell address of occurence of a
vlookup formula.

If VLOOKUP(x,Range,n) evaluates to a cell in Range, then

CELL("Address",INDEX(Range,MATCH(x,INDEX(Range,0,1 )),n))

gives its address.

q 2.00
y 2.00
q 2.00
x 1.00
q 3.00
r 3.00
s 3.00
t 3.00
u 3.00
v 3.00

Range = A1:B10

y 2.00 ok
address $B$10 - wrong address with proposed formula

Harlan,
Thxs a lot for your reply - but I'm getting a incorrect address (should
have been B2)
Could you pls help


Harlan Grove wrote:
wrote...
Is there any formula which can give cell address of occurence of a
vlookup formula.

If VLOOKUP(x,Range,n) evaluates to a cell in Range, then

CELL("Address",INDEX(Range,MATCH(x,INDEX(Range,0,1 )),n))

gives its address.