Forum Discussion
Help please - Excel pulling the wrong row through when I have copied formula down..?
Hi All, I work for a small charity and am trying to set up systems but have hit a stumbling block in excel. I have an MS Form set up with responses going to an Excel online sheet. I need t...
Claire_FCT In the second table try this formula in column F.
=IFERROR(INDEX(TableName[FCT Reference:],ROW()-1),0)... where you replace TableName with whatever the name of the table in the Responses sheet is called.