Hi,
This is Avinash, I need help.
I hope someone can help me out on this as I've been searching on the internet for a solution for a long time without success.
I know someone has probably asked similar question before but the search has brought up too many to go through.
I'm looking to link from a cell in one worksheet to another based on the matching value using the Hyperlink function. I am aware this can be done manualy through the Insert Hyperlink on the Excel Menu but this would be to painful when I have hundreds on items to link. I want a dynamic formula using with a combination of VLookup with Match where I would be able to drag the file and open file directly with that link. I tried but its showing "Can not open the specified file". I tried with Index with match formula but same issue showing "Can not open the specified file".
And in Monthly Sheet data is not showing in tracking sheet using with Vlookup with match.
I have attached the Excel file as an example of what I'm trying to achieve. Your help is much appreciated.
Bookmarks