I need to do this in Excel without VBA. It's a bit embarassing because it should be a "piece of cake" but I'm having a very chewy (hard) time. Sorry to be such a beginner. Here's a small example that I'll apply to a much larger table when I catch the train of thought of how to do this. Let's say I have this table:

3 | 1 | 88 | 111 | |||

5 | 103 | 333 | 81 | |||

10 | 45 | 17 | 8 | |||

x1 | 66 | 11 | 55 | 81 | ||

x2 | 8 | 41 | 408 | 13 | ||

x3 | Index | |||||

x4 |

I need to assign to x1, x2, x3, x4 in their column the data held in a row of numbers that appear above.. The index (cell to the right) is the vertical offset that may vary in this small example from 0 to 4 and indicates which row should have its cells read into x1 to x4. Let's say the index has a value of 2, (index = 0 would point to the first and top row, index = 1 would point to the second row etc..). With index having a value of 2 the formulas in x1 through x4 should dynamically set the four x cells in this case to: x1 = 10, x2 = 45, x3 = 17, x4 = 8. The idea is to have a formula in x1 that one can spread down to the other x cells automatically. (In real life I need to spread that formula down a column of close to 200 cells, and of course the index's value will vary dynamically after reading a row anywhere from zero to 199 in the real life case.) I apologize, Probably there is some clever and straightforward way to do this, but I've made a big salad of Index, Row, Offset, and Column functions and am hoping someone can share their superior knowledge and understanding.... Thank you for your patience on this urgent problem.