Hello,
I'm not sure if this is a solvable problem, but I am wondering if there was to automatically, hyperlink to the cell in my sheet where my indexed list is pulled from.
Paraphrasing, I have a sheet where I pull in the specific information based on met criteria from another sheet in the workbook, using this formula:
=IFERROR(INDEX(INDIRECT("Data!$C$3:$C$500"),MATCH(B$663&" "&ROWS($A$1:A8),Data2!$CO$4:$CO$500,0)),"")
If I need to change the raw data, I need to first find it in my other sheet which doesn't take long, but would make life easier if I was able to select the cell which contains the above formula... and when I select it, it takes me to the cell it's pulling the returned results from.
Thank you,
Kanuck
Bookmarks