Replicating Excel functions INDEX MATCH and VLOOKUP in MATLAB
조회 수: 18 (최근 30일)
이전 댓글 표시
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
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!