External Link with Cell Reference

[alphabo1201]

I have this link that refers to a different workbook.

='N:\Accounting\[Test Mar-2019 MGMT Report.xlsm]Fiscal Year IS'!E32

I want the cell reference to change based on a certain cell or formula

Example would be Cell C2 = March
I know below is incorrect but I want to input that logic.
='N:\Accounting\[Test Mar-2019 MGMT Report.xlsm]Fiscal Year IS'! [=if(C2<6,E21,E32)]



I know I can put the if statement in the front of the whole equation like below but I want to be able to add into the link it self.
=if(C2<6,'N:\Accounting\[Test Mar-2019 MGMT Report.xlsm]Fiscal Year IS'!E21,E32),'N:\Accounting\[Test Mar-2019 MGMT Report.xlsm]Fiscal Year IS'!E32)


Thank you

 

[Special-K99]

Like this?

="'N:\Accounting\[Test Mar-2019 MGMT Report.xlsm]Fiscal Year IS'!"&IF(C2<6,E21,E32)

 

[alphabo1201]

Thank you for your reply.

Yes that's what I am looking for but wouldn't this just have the formula as text and does not show as live value?

 

[Special-K99]

Put it in an INDIRECT() formula.
You may need the file to be open, not sure.