Replace text in a hyperlink based on infromation in another cell

I have an excel file that has 243 rows with excel file names in one column. I want to pull data based on that excel document but don’t want to have to link all 243 documents individually.

 

Example:

CELL A1                                                  CELL B2

Info_2019_04.xlsx              =’https://portal/sites/Library/[Info_2019_04.xlsx]TAB’!$B$6

 

Is there a way that I can create Cell B2 to have the hyperlink information but the information within the [ ] can change based on the data in Cell A1?

By: Virginia

Leave a Reply

Your email address will not be published. Required fields are marked *