You are now following this Submission
- You will see updates in your followed content feed
- You may receive emails, depending on your communication preferences
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
Cite As
Andrea Pinto (2026). complete vlookup function - similar to Excel - both tab/mat (https://ch.mathworks.com/matlabcentral/fileexchange/70168-complete-vlookup-function-similar-to-excel-both-tab-mat), MATLAB Central File Exchange. Retrieved .
Acknowledgements
Inspired by: vlookup - similar to MS Excel function
General Information
- Version 1.0.0 (3.43 KB)
MATLAB Release Compatibility
- Compatible with any release
Platform Compatibility
- Windows
- macOS
- Linux
| Version | Published | Release Notes | Action |
|---|---|---|---|
| 1.0.0 |
