Indirect Formula Referencing Cell Contents

[V L]

Friends: I am in need of the following assistance. I have the following formula in cell B2. =IF(C2="","---",IF(C2="Not Determined","---",IF(C2="Closed","---",IFERROR(INDIRECT(A2&"!$C$11"),"---")))) in a sheet named QL. A2 is a sheet name. I would like the (INDIRECT(A2&"!$C$11") portion of the formula to read the contents of cell AD2 which contains “C11” in the QL sheet. In this way, if I have to move C11 in the source sheet, I can simply change the contents of AD2 and have INDIRECT pick that up. I hope I have explained myself well. TY in advance….

 

[Fluff]

How about

=IF(OR(C2="",C2="Not Determined",C2="Closed"),"---",IFERROR(INDIRECT(A2&"!"&AD2),"---"))

 

[V L]

How about

=IF(OR(C2="",C2="Not Determined",C2="Closed"),"---",IFERROR(INDIRECT(A2&"!"&AD2),"---"))

Thank you. Just needed the syntax... : )

 

[V L]

How about

=IF(OR(C2="",C2="Not Determined",C2="Closed"),"---",IFERROR(INDIRECT(A2&"!"&AD2),"---"))

Thank you. Just needed the syntax... : )

 

[Fluff]

You're welcome & thanks for the feedback.