Jump to the value cell from a Vlookup cell

[AlanZA]

Good day,
I am trying to find a way to jump to the “value” cell that my Vlookup is returning based on the “reference” cell. This is because I may wish to change this value and am looking for a way to get to it easily.

The Vlookup formula used is =VLOOKUP(MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,255),INDIRECT("'"&$A73&"'!"&"$B:$Z"),15,FALSE)

• The worksheet with the Vlookup formulae in it is called “Mar 18”, and the cell position with the Vlookup is Q73.
• The worksheet with the “value” cell is called “S129”, the “reference” cell position is B16 and the “value” cell position is P16.
• The “reference” cell position in “Mar 18” is A73.

I really would appreciate assistance in this.

 

[Special-K99]

What do you mean by "jump" - go to that cell ?
I dont think thats possible with a formula, only via VBA.

MATCH(VLOOKUP(...), range...) will return the row where the data is.

This assumes, as you have implied, that the value will be unique.
If not it will return the row of the first instance that matches.

 

[AlanZA]

What do you mean by "jump" - go to that cell ?
I dont think thats possible with a formula, only via VBA.

MATCH(VLOOKUP(...), range...) will return the row where the data is.

This assumes, as you have implied, that the value will be unique.
If not it will return the row of the first instance that matches.

By Jump I mean where I have the ability either to click on a link/use a Macro hot-key that takes me straight to the cell that the value is being taken from. I am looking for a quick way to get to the cell with the value the Vlookup formula is showing.

 

[Special-K99]

Sounds like a VBA solution but I'm no expert on VBA.