Replicating Excel functions INDEX MATCH and VLOOKUP in MATLAB

조회 수: 18 (최근 30일)
Daniel Gill
Daniel Gill 2019년 9월 20일
편집: Daniel Gill 2019년 9월 20일
Hi
I'm looking to the replicate the INDEX MATCH Excel function in MATLAB.
I have a data table or structure array that includes a set of numbers and I need to find a set of numbers in another separate table (based on two criteria, e.g. credit rating and year). I'm basically trying to search for a set of values in a two-dimensional table, where the x and y values are conditioned by a certain criterion specified in the axis of the original table, as an index match function would do in Excel. I'd then like to take the values found from the separate table and use these in a calculation in the cells of the original table from where the criteria were set.
Similarly, what is the equivalent of VLOOKUP in MATLAB? Is a better way of formulating it to avoid using a LOOKUP function?
Thanks in advance
Dan

답변 (0개)

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

제품


릴리스

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by