vlookup - similar to MS Excel function
버전 1.0.0.0 (1.57 KB) 작성자:
Zhiqiang Zhang
A matrix version of 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]
인용 양식
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. 검색됨 .
MATLAB 릴리스 호환 정보
개발 환경:
R2010b
모든 릴리스와 호환
플랫폼 호환성
Windows macOS Linux카테고리
Help Center 및 MATLAB Answers에서 Characters and Strings에 대해 자세히 알아보기
태그
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!버전 | 게시됨 | 릴리스 정보 | |
---|---|---|---|
1.0.0.0 |