Transforming Result to Meaningful Information

Suppose I have a cell array as such:-

a=cell(5,1);

for i=1:5
    a{i}=i
end

I have an excel file with 2 columns which describe the following:-

1 John
2 Peter
3 Terry
4 Alice
5 Mary

Is there a way to point the cell array result to the following information instead of displaying integer as the final result?

Answer 1

[Fangjun Jiang]

You probably mean indexing. For example

Names={'John', 'Peter','Terry','Alice','Mary'};
ind=[3 1 4 2];
SelectedNames=Names(ind)

It's better to use double array (like the variable 'ind' in the above code) than cell array for your 'a' variable if it contains scalar numerical value in every cell. If you have to use cell array, you can use

a=num2cell(1:5)