Pulling the wrong data

[DMiles]

I have lists of values, e.g. 1, 2, 3, 6, or 12 , 14 , 15 , 16 , 17 , 20 in a column

I need to pull the corresponding statements.

One example of the formula is [InstructionalDelivery][Criterion]

Instead of pulling responses 1, 2, 3, 6 it is returning the statements for 1, 2, 5

Instead of returning for 12 , 14 , 15 , 16 , 17 , 20, it is returning the statements for 11, 13, 14, 15, 16, 19.

All the responses are off by 1 row - what is causing this?

[dbaum · Accepted solution]

It would probably be helpful if you share screenshots showing the lists of column in the relevant tables.

Potentially the issues is that the table containing the "statements" uses [_RowNumber] or another column as its key rather than the column containing the index values that you're referencing.

[DMiles]

Ack, yes, that was exactly the issue! Thanks