Replace column values based on a list

MyArray = Array("Apples", "Pears", "Oranges")

MyArray(0) will give you Apples
MyArray(1) will give you Pears
MyArray(3) will give you Oranges
ubound(MyArray) will give you 3