vlookup - similar to MS Excel function
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]
Cite As
Zhiqiang Zhang (2024). vlookup - similar to MS Excel function (https://www.mathworks.com/matlabcentral/fileexchange/29233-vlookup-similar-to-ms-excel-function), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Acknowledgements
Inspired: complete vlookup function - similar to Excel - both tab/mat, VLOOKUP
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |