How would I write a VLOOKUP which would provide the location as well as provide the location as a hyperlink so I could automatically click and go to the cell I am searching?
Example of the VLOOKUP is on forum, but I can't post the link because I haven't posted at least 10 times in the forum. Good rule.
=ADDRESS(MATCH(J2,A:A,0),1)
I'm currently using the above formula and it returns the location of the information I seek. However; how might the answer cell be turned into a hyperlink for each separate instance of lookup?
I attempted to assign the cell, but then realized it would always go to that single cell no matter what the answer cell had in it. I'm sure this is easier than I'm making it.
Thank you for any help you can provide.
Example of the VLOOKUP is on forum, but I can't post the link because I haven't posted at least 10 times in the forum. Good rule.
=ADDRESS(MATCH(J2,A:A,0),1)
I'm currently using the above formula and it returns the location of the information I seek. However; how might the answer cell be turned into a hyperlink for each separate instance of lookup?
I attempted to assign the cell, but then realized it would always go to that single cell no matter what the answer cell had in it. I'm sure this is easier than I'm making it.
Thank you for any help you can provide.