Incorporating an Indirect function in a formula

[Robert Germain]

Hi,

I have this formula where the sheet name is La Source and I need to incorporate an Indirect function into it for it to be dynamic. I've tried videos to get a better understanding but have not succeeded.

=IF(AND(Schedule!D5='La Source'!C6,Schedule!E5="Salon 281"),Schedule!E5,IF(AND(Schedule!E5<>"Salon 281",Schedule!I5<>"Salon 281"),"",Schedule!E5))


This is the Indirect function that needs to be inserted somewhere and somehow

=INDIRECT("'"&B4&"'!B4")

 

[shaowu459]

you can replace 'La Source'!C6 in the formula with INDIRECT("'"&$B$4&"'!C6"). The value of $B$4 is "La Source" not "'La Source'".

 

[Robert Germain]

Wow! After two days of searching and trying, the answer has resolve my issue! Thank you so much.

 

[shaowu459]

Glad to hear you have solved your problem