I've not thought this through 100% but the following approach should work.
Say you have X and Y which are indexes into a 2D array. X ranges from 0 to 5 and Y ranges from 0 to 10.
Create a calculated PID W that has the expression W=Y*6+X which gives you a linear index into a 2D space as follows:
Code:
W=Y*6+X
X | 0 | 1 | 2 | 3 | 4 | 5 |
Y |----|----|----|----|----|----|
0 | 0 | 1 | 2 | 3 | 4 | 5 |
1 | 6 | 7 | 8 | 9 | 10 | 11 |
...
9 | 54 | 55 | 56 | 57 | 58 | 59 |
10 | 60 | 61 | 62 | 63 | 64 | 65 |
Then create a lookup as follows:
lookup({CALC.W},0,A,1,B,...,64,C,65,D)
Regards
Paul