Replicating Excel functions INDEX MATCH and VLOOKUP in MATLAB

18 views (last 30 days)
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

Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!