What cell is vlookup returning

[jpx]

Can anyone tell me what cell a vlookup is returning?

Example if the vlookup function returns the value 100, what cell did
that value of 100 come from. I have tried
CELL("address",VLOOKUP(E5,G:J,4,FALSE)) but it does not work? Sorry for
so many questions today. Thanks!

 

[Peo Sjoblom]

Try

=CELL("address",INDEX(J1:J1000,MATCH(E5,G1:G1000,0)))