Kindly, how do i insert a link that returns the value of the clickable cell in another specific cell.
From the attached excel, on the Tab named Hyperlink, if i click on the hyperlinked cell H7 i want it to return the value MANAGEMENT on cell E5 (highlighted) and the same way if i click on H11 i want it to return the value OPERATIONS on cell E5 (highlighted).
(I want it to have the same functioning like INDEX function, on the Tab named index , i am able to have a drop down button that returns the value i select on the drop down on cell E2.)
Thanks and Kind Regards
From the attached excel, on the Tab named Hyperlink, if i click on the hyperlinked cell H7 i want it to return the value MANAGEMENT on cell E5 (highlighted) and the same way if i click on H11 i want it to return the value OPERATIONS on cell E5 (highlighted).
(I want it to have the same functioning like INDEX function, on the Tab named index , i am able to have a drop down button that returns the value i select on the drop down on cell E2.)
Thanks and Kind Regards