As an example, in cell A1 - I have text of someone's name (assume name of
"John")
in cell A2 I have a number (assume number = 1).
In cell B2, I have created a formula that says
="'["&A2&$A$1&".xls]Sheet1!'$D17", which equates to text that says
'[1John.xls]Sheet1!'$D17
I wish to be able to use this formula to create a link to 1John.xls within
an "if" formula, rather than having to manually type in the link for each
different number or name. Is it possible???

Thanks