# How to select the Nth item in a list where N is stored in array B? [closed]

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,....