Another interesting dilemma to solve.
Using this formula:
from the thread: http://www.excelforum.com/excel-misc...ing-cells.html
I need to replace D4 with something along the lines of:
I am making this much harder than needed as a lot of the information in the cells are not entered directly into the cell, but functions referencing other worksheets. Any ideas on how to go about this? I am sort of familiar with the INDEX&MATCH functions but wasn't sure how to insert it into the HYPERLINK function.