Forum

Notifications
Clear all

In Hyperlink formula in location, the folder name to be taken from a cell side by it

2 Posts
2 Users
0 Reactions
63 Views
(@durga786)
Posts: 1
New Member
Topic starter
 

Existing Formula : HYPERLINK("F:Study MaterialOrder2017" & A3 & ".docx",A3)

Looking for : syntax as : HYPERLINK("F:Study Material+C32017" & A3 & ".docx",A3)

Now in above the folder name i.e. "Order" to be taken from cell "C3" since there are different folder whose name is appear in "C" column, so instead of typing the folder name, is it easy if it takes the name from the cell from "C" column...

 
Posted : 14/03/2019 5:27 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Try

=HYPERLINK("F:Study Material"&C3&"2017" & A3 & ".docx",A3)

 
Posted : 14/03/2019 7:24 am
Share: