This is matrix version of VLOOKUP similar to MS Excel function.
Return matrix b which has equal size as m and the values are taken from
from the n column of lookup table lut. It will replace all NaN with zero.
example how to use:
Type this 2 matrix data
> m = [ 1 2 0; 3 4 1]
> lut = [0 0.5 12; 1 0.8 25; 2 0.4 32; 3 0.7 41]
produces
m = [ 1 2 0;
3 4 1]
lut = [0 0.5 12;
1 0.8 25;
2 0.4 32;
3 0.7 41]
> b=vlookup(m,lut,3)
=> [25 32 12;
41 0 25]
> b=vlookup(m,lut,2)
=> [0.8 0.4 0.5;
0.7 0 0.8]
Written by Kardi Teknomo http://people.revoledu.com/kardi/
Note: the code consist of three different versions of vlookup, the fastest is only consist of two lines code uncommented.
Zitieren als
Kardi Teknomo (2024). VLOOKUP (https://www.mathworks.com/matlabcentral/fileexchange/12453-vlookup), MATLAB Central File Exchange. Abgerufen .
Kompatibilität der MATLAB-Version
Plattform-Kompatibilität
Windows macOS LinuxKategorien
- MATLAB > Language Fundamentals > Matrices and Arrays >
- MATLAB > Language Fundamentals > Data Types > Numeric Types >
- MATLAB > Language Fundamentals > Data Types > Tables >
Tags
Quellenangaben
Inspiriert von: 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!Live Editor erkunden
Erstellen Sie Skripte mit Code, Ausgabe und formatiertem Text in einem einzigen ausführbaren Dokument.
Version | Veröffentlicht | Versionshinweise | |
---|---|---|---|
1.0.0.0 | update the license |