清空筛选条件
清空筛选条件

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

1 次查看（过去 30 天）
fede
fede 2016-4-10
评论： Marc 2016-4-10
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
  1 个评论
Marc
Marc 2016-4-10
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.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Image Analyst
Image Analyst 2016-4-10
Try ismember().

类别

在 Help Center 和 File Exchange 中查找有关 Multidimensional Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by