complete vlookup function - similar to Excel - both tab/mat

バージョン 1.0.0 (3.43 KB) 作成者: Andrea Pinto
A complete vlookup function, similar to MS Excel function, which works both with matrices and tables and with any type of lookupvalue.
ダウンロード: 74
更新 2019/2/1

ライセンスの表示

This function should work as the vlookup function in Excel

vlookup looks for the 'look up value' in the 'luv-column'-th column of 'matrix_table' and return the corresponding 'mt_col'-th element of 'matrix_table' in the same row.

example:
matrix
1 2 3
4 5 6
7 8 9

luv = 6

[content,index] = vlookup(luv,matrix,3,1,0)

vlookup will look for the "luv" in the "matrix" in column 3 and will return the value in the same row in column 1 (4).

Legenda:
lookupvalue = can be any of the following types: [char / string / categorical / numeric / calendar duration / duration / datetime]
matrix_table = can be either a matrix or table
luv_col = can be any of the following types: [char / string / categorical / numeric / calendar duration / duration / datetime]
mt_col = can be any type
k = value to be shown in case the index is an empty vector

luv_col = 1 by default if omitted
k = [ ] by default if omitted

Copyright: andrea.pinto@studbocconi.it, 2019
Author: https://it.mathworks.com/matlabcentral/profile/authors/13958739-andrea-pinto

引用

Andrea Pinto (2024). complete vlookup function - similar to Excel - both tab/mat (https://www.mathworks.com/matlabcentral/fileexchange/70168-complete-vlookup-function-similar-to-excel-both-tab-mat), MATLAB Central File Exchange. 取得済み .

MATLAB リリースの互換性
作成: R2018b
すべてのリリースと互換性あり
プラットフォームの互換性
Windows macOS Linux
カテゴリ
Help Center および MATLAB AnswersSpreadsheets についてさらに検索
謝辞

ヒントを得たファイル: vlookup - similar to MS Excel function

Community Treasure Hunt

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

Start Hunting!
バージョン 公開済み リリース ノート
1.0.0