Replicating Excel functions INDEX MATCH and VLOOKUP in MATLAB
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!