File Exchange

image thumbnail

VLOOKUP

version 1.0 (1.56 KB) by

vlookup tutorial

2 Downloads

Updated

View License

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.

Comments and Ratings (4)

ruchit chaturvedi

I agree with Jeff. Have to be very careful since the function does not give the exact match.

FATEN SOLTANI

comment pouvant savoir ? quelle couleur correspond une valeur de pixel

Jeff H

This doesn't do what a vlookup does, at least the most commonly used (exact match) version. In your example, if I vlookup(1.5,lut,2) I should get back a NaN - 1.5 is not an element of lut(:,1). However your function would interpolate and yield 0.6. Dangerous!

KALAI KOVAN

Updates

1.0

update the license

MATLAB Release
MATLAB 5.2 (R10)
Acknowledgements

Inspired by: vlookup - similar to MS Excel function

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Win prizes and improve your MATLAB skills

Play today