is there an equivalent vlookup formula excel in matlab of a string?

I have the following matrix:

Stock_1 Stock_2 ..... Stock_n
23.5    25.8          29.6
24.5    85.5 ........ 59.2
....    ....          ....

A matrix (nxn), where in the first row ther'is the name of stocks, and in the other row the historical price. Then, I have another matrix of pair of stocks, for example:

Stock_1  Stock_2
Stock_3 Stock_5
......  ......

and so on.... I want a for loop that give me for all pair the respective stock prince. For example for the first pair: Stock_1 Stock_2 I want to extrapolate the following matrix:

Stock_1 Stock_2
23.5   25.8
24.5   85.2

and so on. Thxs

[Marc]

Do you have a matrix or are you using a table?

If you have never used a table, I would recommend trying it for this type of data setup.

Answer 1

[Image Analyst]

Try ismember().