Forum Discussion
HELP! Formula not working
In 'Student Lesson Data'!E4 you call in formula Student Responses'!I6:M6 and after that add implicit intersection '@' in front of them. That returns !Value# error, rows 6 and 4 are not intersected.
Not sure what you try to do. In brief, '@' is only for values in the same row of this or another sheet.
In 'Student Lesson Data'!E4 you call in formula Student Responses'!I6:M6 and after that add implicit intersection '@' in front of them. That returns !Value# error, rows 6 and 4 are not intersected.
Not sure what you try to do. In brief, '@' is only for values in the same row of this or another sheet.
Thanks! SergeiBaklan
I did not have the @in my formula initially, but when I only had the first column, it created a spill into the next column which I did not want. I have taken them out and the formula is working the way I want.
