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

版本 1.0.0 (3.4 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.
75.0 次下载
更新时间 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 CenterMATLAB Answers 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!
版本 已发布 发行说明
1.0.0