vlookup - similar to MS Excel function

Versione 1.0.0.0 (1,57 KB) da Zhiqiang Zhang
A matrix version of VLOOKUP similar to MS Excel function.
4.6
(8)
2,2K download
Aggiornato 2 nov 2010

Visualizza la licenza

VLOOKUP the function as vlookup in Excel

[content, index] = vlookup(m, e, column, lookcolumn) look for 'e' in the 'lookcolumn'-th column of 'm', and return the coresponding 'column'-th element of 'm' in the same row.

the 'm' could be a numeric matrix of a cell matrix.

lookcolumn is 1 by default if omitted.

Example:

m = {1, 'a', [2 3];
2, 'b', 'cd'
3, 'a', true;};
[content, index] = vlookup(m, 'a', 3, 2) then
content = {[2 3], 1};
index = [1;3]

author: http://zhiqiang.org/blog/tag/matlab

Cita come

Zhiqiang Zhang (2025). vlookup - similar to MS Excel function (https://it.mathworks.com/matlabcentral/fileexchange/29233-vlookup-similar-to-ms-excel-function), MATLAB Central File Exchange. Recuperato .

Compatibilità della release di MATLAB
Creato con R2010b
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux
Categorie
Scopri di più su Characters and Strings in Help Center e MATLAB Answers
Tag Aggiungi tag

Community Treasure Hunt

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

Start Hunting!

Versione Pubblicato Note della release
1.0.0.0