The attached images of excel files give a full explanation of what I am looking to do. Essentially to get a cell address based on the adjacent cell's content and deliver that cell address. Then to have a formula update automatically to provide a link to said cell address as it changes due to...