File Exchange

image thumbnail

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

version 1.0.0 (3.43 KB) by Andrea Pinto
A complete vlookup function, similar to MS Excel function, which works both with matrices and tables and with any type of lookupvalue.

1 Download

Updated 01 Feb 2019

View License

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 (2021). 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. Retrieved .

Comments and Ratings (1)

Stephen Cobeldick

The MATLAB way:

>> idx = matrix(:,3)==luv;
>> val = matrix(idx,1)
val = 4

MATLAB Release Compatibility
Created with R2018b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired by: 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!