There are 100 cells in column A, each with a single (text) character. Column B contains 100 integers (N) in the range 1-100, with the possibility of duplications and with some numbers missing. I want each of 100 cells in column C to contain the contents of A as determined by each N in column B.

eg. Col A contains a,b,c,d,e,f,g,h,…; Col B contains 1,2,3,5,4,4,1,1,…; Col C contains a,b,c,e,d,d,a,a,…

If your `100`

is actually a **fix** number, and the texts in column A also start with the first row as the contents in column B do, you may use `=INDEX($A1:$A100;$B1)`

in cell `C1`

and fill the formula down till `C100`

. Regard the difference between absolute and relative addresing! Only the `1`

of the cell addres `$B1`

in the formula above is relative.

This is a rather raw method. If you want to be more flexible use the OFFSET function. Feel free to come back with additional questions in this case.

(Generally: You may want to read the Calc guide. With respect to your question the versions do not differ.)

Thanks. I found that “=INDEX($A$1:$A$100,$B1)” worked well.

Of course. The question is if it will still work well after some *enhancements to / scaling up / adaptions of / …* your sheets. OFFSET can take parameters controlling the size of the data range, e.g.

(You may check the ‘Solved’ mark next to the answer.)