How to keep hyperlink in cells being accessed with IF function across workbooks?

jandy 

Hi

You can use a HYPERLINK function which requires 2 arguments:

=HYPERLINK(link_location,friendly_name)

The First Argument (Link Location) should follow a pattern: Workbook Name, Worksheet Name,  exclamation mark, Cell Reference

You can replace the workbook Name by a number sign if the Hyperlink is in the same file.

The Second Argument is a user friendly Name

I invite you to watch my tutorial in which I create such function by clicking on the link: (at 9:50 minute)

https://www.youtube.com/watch?v=FeKgWSD8IWc

Hope that helps

Nabil Mourad