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.