This might be very trivial, but I was not able to obtain any concrete result from my Google searches, so asking here.
I want to fill a column with the content of some other column (in some other sheet). The value at the existing place is not organised to the current requirements, so I just can't directly assign it to the new column. I have another column that specifies the ordering for the new column. So, I want to create my new column with the help of this ordering.
In short, I was wishing to assign my new column as sheet1!A${sheet2!A1}
(this doesn't work).
Say, if I have value 23 at sheet2!A1
, then the corresponding value in the new column should be of the cell sheet1!A23
.