Is there any function in Matlab that can serve as "VLOOKUP" of Excel?

26 次查看（过去 30 天）
Jennifer Arellana
Jennifer Arellana 2021-4-27
评论： Qishen Ye 2023-1-19
I am making a model that gives me this information:
aux2 =
7×2 cell array
{'100'} {[8.7856e+08]}
{'010'} {[7.8487e+09]}
{'110'} {[8.7272e+09]}
{'001'} {[5.4068e+09]}
{'101'} {[6.2854e+09]}
{'011'} {[1.3361e+10]}
{'111'} {[1.4243e+10]}
The problem I have is that I need these results to have the following order (just look at column 1 to understand the order):
final1 =
7×1 cell array
{'100'}
{'010'}
{'001'}
{'110'}
{'101'}
{'011'}
{'111'}
I think that a solution could be something like what the Excel function "VLOOKUP" does, the logic of this is that it looks for each value of column 1 of the aux2 array in column 1 of the final array1 and assigns the value of column 2 of the aux2 array in the order of column 1 of the final array1.
This is an idea but if you can think of a better way, I would appreciate any help, thanks!

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

采纳的回答

Fangjun Jiang
Fangjun Jiang 2021-4-27
[~,index]=ismember(final1,aux2(:,1))
newData=aux2(index,:)

更多回答（0 个）

类别

在 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