Spreadsheet: 726938d1617616159-select-a-cell-from-a-list-of-100-cells-example
Sheet: INPUT

WORKING example |  | X |  |  | Visual example | 1 |  | 0, 1, 2, | produces cells from column A1 in Sentences! Formerly X
with letters |  |  |  |  | with numbers | a1 |  | 3, 4, 5, 6 | produces cells from column A2 in Sentences! Formerly Y
 |  |  |  |  |  |  |  | 7, 8, 9 | produces cells from column A3 in Sentences! Formerly Z
 |  | Z |  |  |  | 1
 |  |  |  |  |  | a2 |  | Numbers from zero to nine are inputted in the yellow field.
 |  |  |  |  |  |  |  | Cells from columns A, B and C are produced in the blue field
 |  | X |  |  |  | 0 |  | Please note that, in the blue field, I have simply labelled the columns a, b and c and counted them numerically as they would appear.
 |  |  |  |  |  | a3
 |  | Y |  |  |  | 5
 |  |  |  |  |  | b1
 |  | Y |  |  |  | 9
 |  |  |  |  |  | c1
 |  |  |  |  |  |  |  | The existing (and working) formula is in column C.
 |  | Z |  |  |  | 8 |  | The visual demonstration is in column G.
 |  |  |  |  |  | c2
 |  | X |  |  |  | 5 |  | Explanation:
 |  |  |  |  |  | b2
 |  |  |  |  |  |  |  | As before, the input should be in the yellow field.
 |  | Z |  |  |  | 4 |  | As before, the input will produce a cell from columns A, B or C from the second sheet (Sentences!) in the blue field.
 |  |  |  |  |  | b3 |  | What is different is that the input should be numerical between 0-9 (not text).
 |  | X |  |  |  | 1 |  | Here, I require a threefold division. Instead of x, y, z, I need the following:
 |  |  |  |  |  | a4
 |  |  |  |  |  |  |  | X should be replaced by 0, 1, 2 and should refer to Sentences! Column A
 |  | Z |  |  |  | 4 |  | Y should be replaced by 3, 4, 5, 6 and should refer to Sentences! Column B
 |  |  |  |  |  | b4 |  | Z should be replaced by 7, 8, 9 and should refer to Sentences! Column C
 |  | X |  |  |  | 9 |  | Please retain the principles already operative in the existing formula:
 |  |  |  |  |  | c3 |  | 1.    The formula will always pick the next cell from the column (e.g. a1, a2, a3, …)
 |  |  |  |  |  |  |  | 2.    Each column in Sentences! has up to 100 cells.
 |  | Y |  |  |  | 0 |  | 3.    One can input any number of cells (e.g. either 1, 34, 67 or the maximum 100 cells) and the algorithm will ignore the blank cells.
 |  |  |  |  |  | a5 |  | 4.    The formula will jump back to the first cell once the last inputted cell has been used, e.g. if only 68 cells have been inputted in Column A, then the algorithm will jump back to cell 1 after having used cell 68: cyclicity.
 |  | Y |  |  |  | 0 |  | In the future, I would need the same principles as above but only with a twofold division (e.g. 0, 1, 2, 3, 4 refers to Sentences! Column A and 5, 6, 7, 8, 9 refers to Sentences! Column B; there won’t be a column C).
 |  |  |  |  |  | a6 |  | I think I would be able to deduce this from the formula. If there are intricacies involved, perhaps you could give me a pointer.
 |  | Z |  |  |  | 6 |  | Due to a lot of data input, the file might potentially become quite large, so it would be great if volatile functions could be avoided if this is at all possible.
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Thank you very much.
 |  | X |  |  |  | 2
 |  |  |  |  |  | a7
 |  | X |  |  |  | 7
 |  |  |  |  |  | c4