I am trying to use INDIRECT to dynamically reference another spreadsheet, but I am getting a ref error. The formula that I am using is =INDIRECT("'"&B3&"["&B4&"]Assignment Grades'!E10"). When I take the input to INDIRECT and throw an equals sign in front of it, I get this as the output: 'c:usersahmeedownloads[MATH_110_Homework_1_scores.xlsx]Assignment […]