Replicating Excel functions INDEX MATCH and VLOOKUP in MATLAB

5 vues (au cours des 30 derniers jours)
Daniel Gill
Daniel Gill le 20 Sep 2019
Modifié(e) : Daniel Gill le 20 Sep 2019
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

Réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Produits


Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by