Hello guys so I have this formula on say A2.
=IFERROR(IF(INDIRECT("'CAR 002'!G25")="x","Employer's Request",IF(INDIRECT("'CAR 002'!L25")="x","Contractor Request",IF(INDIRECT("'CAR 002'!R25")="x","Consultant Request"))),"")
How can i copy this formula on A3 but changing CAR 002 to CAR 003 and...